Get Free Trial

Configure Date Format

brodybinks 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

3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster March 23, 2017

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 –
Please let us know if everything works fine for you.
Best regards,

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

Ian Sadovy Ian Sadovy Flexmonster March 30, 2017

Please take a look at the working sample – (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?

Please login or Register to Submit Answer