Configure Date Format
I am having difficulty configuring date in a pivot. I changed my XML config params like this.
but the dates still do not show up correctly. They are showing either as dd/mm/yyyy and sometimes yyyy/mm/dd
Thank you for your question. It seems that your datePatern is not correct. The correct one will look like the following:
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.
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
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?