asked on February 25, 2021
Hi,
I am using defaultDateType "date string" and datePattern "MM/dd/yyyy" and all of my dates display as December 31 1969. I tried changing defaultDateType and datePattern to default values but that did not help.
Where should I look? Please help.
Thanks,
Andrey
⋅ February 26, 2021
Hello, Andrey,
Thank you for contacting us.
We did not manage to reproduce the issue on the latest version of the component (2.8.27).
Please check out the JSFiddle we prepared while trying to reproduce the described behavior.
If it does not help, please modify the JSFiddle in the way the issue can be observed.
Please let us know if it helps.
Our team is looking forward to hearing from you.
Kind regards,
Illia
⋅ February 26, 2021
Hi Illia,
Thanks for the quick response and the JSFiddle example. I think in my case the json is server-side generated and the dates formatted using MS ASP.NET json format so they look like this: Date: "/Date(1614142800000)/". Can pivot grid handle this format? What would you recommend?
Thanks,
Andrey
⋅ March 1, 2021
Hello, Andrey,
Thank you for your response.
We would like to kindly explain that Flexmonster supports the ISO 8601 date format, for example: "2016-03-20" (just date) or "2016-03-20T14:48:00" (date and time). Other formats aren’t officially supported and may have unexpected results.
Our team kindly recommends passing the dates to Flexmonster in the ISO 8601 date format. Also, it is possible to preprocess the JSON data before passing it to Flexmonster. Please see a simple JSFiddle example for illustration.
We would like to mention that it is also possible to pass a timestamp. In such case, a date data type needs to be specified for the corresponding field. The date data type could be set via the mapping property. Here is a JSFiddle example demonstrating this approach.
Please let us know if this helps. If further questions arise, please feel free to reach out.
Kind regards,
Vera
⋅ March 1, 2021
Hi Vera,
We found the way to format the dates using ISO 8601 format.
Thank you for your help,
Andrey
⋅ March 2, 2021
Hello, Andrey,
Thank you for your reply.
We are happy to hear that everything works.
Should any further questions arise, please feel free to reach out.
Kind regards,
Vera
