asked on June 1, 2022
Hello, i´m using the type format of "year/month/day" in the month configuration on my pivot but he puts a 2001 year that is a number who don´t correspond to any month request.
⋅ June 2, 2022
Hello, Vanessa!
Thank you for contacting us.
We haven't managed to reproduce the described behavior of the "year/month/day" datatype on our side.
Kindly note that Flexmonster expects to have the input date in ISO 8601 format:
{
"Date": "2021-04-25",
"Datetime": "2021-04-25T21:30:05+03:00"
}
JSON, CSV, and Custom API data sources also support Unix timestamps.
Other formats aren't officially supported and may have unexpected results.
Please make sure that your input date format is supported by Flexmonster.
You can find more details on date and time formatting in our docs: https://www.flexmonster.com/doc/date-and-time-formatting/.
We have also prepared an example with "year/month/day" datatype: https://jsfiddle.net/flexmonster/2yqk4arL/.
If the suggestions above didn't help resolve the issue, could you please modify our example to make your case reproducible?
Looking forward to your response.
Regards,
Solomiia
⋅ June 9, 2022
Hello, Vanessa!
Hope you are having a great week.
Our team is wondering if you had a chance to check out the suggested approach on how to use the year/month/date datatype.
Could you please let us know if it was helpful to solve the case?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ June 16, 2022
Hello, Vanessa!
Hope you are doing well.
Could you please let us know if the suggested date formatting approach was helpful?
Looking forward to your response.
Regards,
Solomiia
⋅ July 6, 2022
yes, but we notice that our data forma works better if we treat him like integer.
⋅ July 7, 2022
Hello, Vanessa!
Thank you for letting us know.
Feel free to ask in case of any other questions.
Regards,
Solomiia