asked on January 16, 2020
Dears,
When sorting a date type column, Flexmonster sort this field as a string.
Could you adjust the report to sort date correctly?
Best regards,
Jefferson Luis
⋅ January 20, 2020
Hi Jefferson,
Thank you for writing to us.
We would suggest trying to set the dates in your raw data in the ISO 8601 date format, that is "2020-02-23" (date) or "2020-02-23T16:58:30" (date and time).
This format is standard in Flexmonster and ensures that the input data will be recognized as a date. If you are using a different date format, unrecognized by Flexmonster or your browser, the data will be parsed as a string by default.
Additionally, we would recommend setting the data type for corresponding fields explicitly. This can be achieved by using the Mapping object or by setting the configurations directly in the Data Source object (the latter only available for CSV and JSON data sources). For more information on this approach please check out the following page: https://www.flexmonster.com/doc/mapping/
Please let us know if this helps.
Best regards,
Mykhailo
