Currently if we have a date field – it gets broken down into three different fields in Flexmonster – Day, Month, Year. Is there a configuration setting that will allow me to obtain a single date value?
E.g. Assume the date is 1st Jan 2019. In the grid i see three columns – Day, Month, Year. Is there a configuration setting that will allow me to obtain a single date value that displays the data as 01/01/2019?
Hello, Samyukta Sunku,
Thank you for your question.
We would like to note that Flexmonster can represent dates in different formats.
Here are two ways you can achieve the desired output:
1. By adding a prefix:
To represent a date as dd/MM/yyyy, the following prefix needs to be added to the corresponding column:
This will indicate that those fields will be formatted using a date pattern (default is “dd/MM/yyyy”).
As a result, values in the Birthday column will be displayed in the format “dd/MM/yyyy”.
Please see our data types in CSV guide for more details.
2. By specifying the
defaultDateType parameter in the options object:
defaultDateType parameter is used to specify which data types should be applied to date fields by default (“date”, “date string”, “year/month/day”, “year/quarter/month/day” or “datetime”) for CSV and JSON data sources.
This way data doesn’t need to be modified.
Please let us know if this works and if you have further questions.