Don´t know where this year in month column came from

Re-Open
Vanessa Aguiar 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.

Attachments:
Screenshot_9.png

5 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Vanessa Aguiar July 6, 2022

yes, but we notice that our data forma works better if we treat him like integer.

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster July 7, 2022

Hello, Vanessa!

Thank you for letting us know.

Feel free to ask in case of any other questions.

Regards,
Solomiia

Please login or Register to Submit Answer