asked on January 5, 2021
Hello,
I have a problem with the date format. I wish all my dates were in the format: yyyy-MM-dd. In my example, a date "Date de début d'exécution du plan" doesn't want to be in this format.
I don't understand because for others, it's work ..
I looked at forums with similar issues but couldn't find the solution.
Can you help me ?
Thank you
⋅ January 6, 2021
Hello,
I think I found the problem but I still don't have a solution.
When a date has 01 in the month AND 01 in the day AND that it appears first in the JSON, this does not work. Example: 2020-01-01 or 2018-01-01 ...
⋅ January 8, 2021
Hi Djilan,
Thank you for posting your question.
We've managed to reproduce the strange field behavior when the first data entry contains a 01-01 date – our team will take a look at this and provide a fix with our upcoming release on ETA Jan 25th.
In the meantime, we'd suggest configuring the date fields' type through the Mapping Object on your side:
dataSource: {
mapping: {
"Date1": {
type: "date string"
},
...
}
...
}
If you set the field's type to a specific date type explicitly, the pivot table parses the data correctly.
Also, as a side note, on your date3.png screenshot, we've noticed that the Global Object is misconfigured: the licenseKey property should be outside the Global/Report object, while the defaultDateType and the datePattern properties should be specified inside the Options Object.
We hope this helps.
Best regards,
Mykhailo
⋅ January 26, 2021
Hi Djilan,
We are glad to inform you that the issue with parsing date fields was fixed.
This is included in the 2.8.25 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if this helps.
Kind regards,
Mykhailo
⋅ January 27, 2021
Thank you !
This question is now closed