🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

How to sort column of date type?

Jefferson Luis Pereira dos Santos asked on January 16, 2020

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

1 answer

Mykhailo Halaida Mykhailo Halaida Flexmonster 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,

Please login or Register to Submit Answer