Is there a way to display numeric month with string names?
e.g. 01 => January
if so, how can we define language, and how can we do short forms? (e.g. Jan)
thank you
Hello, Michael!
Thank you for writing to us.
Our team wants to inform you that there are several ways to format months' names from the date fields for JSON and CSV data sources.
1. The following approach is used when you need to set one default date format for all date fields in Flexmonster.
The datePattern
option is applied for all columns with the date string
data type. Also, we used defaultDateType
property with date string
value. That makes Flexmonster treat all the date columns as date string
.
report:{
options: {
defaultDateType: "date string",
datePattern: "dd MMM YYYY"
}
slice: {...}
}
You can try this approach on jsFiddle: https://jsfiddle.net/flexmonster/x41q3m7v/
2. If you need to format dates only for the specific column, we recommend defining date formats in the mapping
property of the dataSource
object:
dataSource:{ filename:{...}, mapping: { "Date": { uniqueName:"Date String", type:"date string", format:"dd MMM YYYY" } } }
We have prepared a simple example for visualization: https://jsfiddle.net/flexmonster/zLu1p639/
For more details, please look through our docs on this topic: https://www.flexmonster.com/doc/date-and-time-formatting
How to define the language
You can specify the localization for all months' names in the language you want. Here's our localization guide: https://www.flexmonster.com/doc/localizing-component/
Please let us know if it works for you. Feel free to contact us if any further questions arise.
Regards,
Solomiia.
Hello, Michael!
Hope you are doing well.
Our team is wondering if you had a chance to try the suggested month formatting approaches. Could you please let us know if our response helped?
Looking forward to hearing from you.
Regards,
Solomiia.
Hello, Michael!
Hope you are having a great week.
Just checking in to ask if our response helped you with your question.
We will be glad to hear your feedback.
Regards,
Solomiia