asked on March 23, 2017
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
⋅ 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.
⋅ 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
⋅ 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
