Date as a string
I want to build a report (flat one) from JSON and one of the column is
In the fields I am getting DateFrom.Year,DateFrom.Month and DateFrom. Day – how to put complete date as a column in the report.
Thanks for help.
Thank you for writing to us.
The default date format can be overridden by specifying the field type in the first object of the input JSON data:
You can find more info on this approach on the following documentation page: https://www.webdatarocks.com/doc/data-types-in-json/
Thanks for the reply. It helps. Is ip possible to change datetime format to yyyy-mm-dd?
Thank you for your feedback.
Date formatting as achievable using the
datePattern property for the
date string data type and the
dateTimePattern for the
datetime data type.
Mentioned properties can be defined within the
Detailed information about the
options object in our documentation.
We hope it helps.
You are welcome to contact us in case additional questions appear.