Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How to sort column of date type?

Answered
Jefferson Luis Pereira dos Santos 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

1 answer

Public
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,
Mykhailo

Please login or Register to Submit Answer