Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
Looks to still be broken almost 3 years later???
Copy link to clipboard
Copied
Yep, but to be clear, you can still just format it yourself.
Copy link to clipboard
Copied
Yes, I just have add 5 more (duplicate) fields to my table...
Copy link to clipboard
Copied
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.