date formatting

[TallVegan]

Document Generation API: How to format merged data date values? There are very basic maths function but no function for (re)formatting a date that has been supplied in http://en.wikipedia.org/wiki/ISO_8601 format.

[cfjedimaster]

Hi, Document Generation uses JSONata behind the scenes, but currently, date formatting (https://docs.jsonata.org/date-time-functions) is broken. I've reported it. You can, however, format your dates in your data *before* you send it to our API. Make sense?

[Tucker35180782sk40]

Looks to still be broken almost 3 years later???

[Raymond Camden]

Yep, but to be clear, you can still just format it yourself. 

[Tucker35180782sk40]

Yes, I just have add 5 more (duplicate) fields to my table...

[Raymond Camden]

A little late, but to be clear, you don't have to add anything to your database. You would get your data, reformat the values in your code before sending it to the API.