Menu
Download Free Trial

Configure Date Format

Answered

I am having difficulty configuring date in a pivot. I changed my XML config params like this.
 
<param name=”datePattern”>mm/dd/yyyy</param>
 
but the dates still do not show up correctly. They are showing either as dd/mm/yyyy and sometimes yyyy/mm/dd

3 answers

Public
Dmytro Zvazhii Flexmonster March 23, 2017

Hello,
Thank you for your question. It seems that your datePatern is not correct. The correct one will look like the following:
<param name="datePattern">MM/dd/yyyy</param>
Please note that the "datePattern" format could be applied only for the "dateString" (ds+) type. Also, you are welcome to visit our documentation page about date and time formatting – http://www.flexmonster.com/doc/date-and-time-formatting/.
Please let us know if everything works fine for you.
Best regards,
Dmytro.

Public
brodybinks March 29, 2017

I set my config now to reflect <param name=”datePattern”>MM/dd/yyyy</param> and I am still seeing dates in dd/MM/yyy format

Public
Ian Sadovy Flexmonster March 30, 2017

Hello,
 
Please take a look at the working sample – http://jsfiddle.net/flexmonster/utn8buyn/ (it uses JSON report instead of XML, but an idea is the same).
Can we have a sample of your code and data source to check?
 
Regards,
Ian

Please login or Register to Submit Answer