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

Answered
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

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