Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
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