asked on May 8, 2019
Hi,
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?
Thank You,
Samyukta Sunku
⋅ May 9, 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: ds+
This will indicate that those fields will be formatted using a date pattern (default is "dd/MM/yyyy").
For example:
Name,ds+Birthday,...
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:
The 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.
Best Regards,
Vera
