asked on March 20, 2022
Hi,
we are using already date fields which are working great. Now I wanted to introduce a date/time field. I looked up the format how it should come up in https://www.flexmonster.com/doc/date-and-time-formatting/#input-date-format. We are using the flexmonster data server, and I formated a field in a data source so that the format comes up like "2015-03-27T22:18:17+00:00". But then in the report later on the content is just shown as plain text., as you can see in the attached screenshot.
Am I doing something wrong? Does the frontend also needs to be configured to recognize the field as a date/time field?
Thanks,
Benni
⋅ March 21, 2022
Hi, Benni!
Thank you for the detailed description of the issue.
To recognize dates in this format, you should set type: "datetime" for the field containing dates inside the mapping property of the dataSource object. Here is a code snippet showing how to set the datetime type for a field:
mapping: {
"Date": {
"type": "datetime"
}
}
Also, you can check the following JSFiddle example: https://jsfiddle.net/flexmonster/a78x9mwg/.
We hope you will find this answer helpful. Please let us know if this works for you.
Best Regards,
Maksym
⋅ March 28, 2022
Hi, Benni!
We were wondering if you had time to try a mapping approach for the datetime date format issue. Looking forward for your response.
Best Regards,
Maksym