Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

how to specify one date format per col ?

Answered
Patrick TAVARIS asked on February 19, 2020

Hi,
i would like to know if there is a way to specify one date format per column ?
I have a dataset with x columns representing dates in differents formats (iso US, FR version, short date, quarter, day of week, …).
Is there a way to specify the date format for each column ? (and not one date format for all date columns of the dataset ?)
 
Currently, I use string foormat for these columns and make the format server side.

4 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 20, 2020

Hi Patrick,
 
Thank you for posting your question.
 
Kindly note that at the moment only one date representation format can be specified for the report. 
 
A potential workaround involves using the customizeCell API call to modify the date string value inside the cell depending on its hierarchy. However, this approach does not offer significant advantages when compared with the method of server-side preprocessing you’ve mentioned. With that in mind, we would suggest sticking with this approach for now.
 
Please let us know if you have any other questions we can help you with.
 
Best regards,
Mykhailo

Public
Patrick TAVARIS February 21, 2020

Hi,
I think it is a huge leak and I also think it is not so complicated your side to add one date format per column (maybe in the column mapping part…).
Why it is a huge leak ?
For example to be able to sort date columns chronologically even if an alphabetical sort order could be different (especially in french of DD/MM/YYYY format).
Currently we cannot have both a “user friendly date format” + a chronologically ordered columns 🙁
 
I hope you will be able to consider it as a great evolution 🙂
 
Regards
 
L.
 
P.S : flexmonster is still very powerfull and we still love it 🙂

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 24, 2020

Hi Patrick,
 
Thank you for providing your suggestions. 
 
I talked to our developer team about this feature and they informed me that we’ve received similar requests before. All in all, this feature seems reasonable to us and while we cannot provide you with an exact ETA, we are going to introduce it in one of our nearest releases.
 
We will reach out to you once there are any further updates on this matter.
 
Please let us know if you have any other questions we can help you with in the meantime.
 
Best regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster March 12, 2020

Hi Patrick,
 
We are glad to inform you that the new format mapping property is now available for JSON/CSV/Custom API data sources to apply date/time formatting for individual fields.
 
This is available in the 2.8.2 version of Flexmonster: https://www.flexmonster.com/release-notes/
 
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Feel free to write to us in case of questions.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer