If you need this for showing the datetime without the milliseconds: formatDateTime(‘[%CurrentDateTime%]’, “yyyy/MM/dd HH:mm:ss”)
If you need this for calculating difference between datetime1 anddatetime2: secondsBetween($Date1, $Date2)
Or do you need it for something else?
I have resolved this issue, I changed the json primitive type of the date to be a string and used formateDateTime to convert it to the format ‘1987-12-31T23:59:00’ all good now.
Hi Tim, thank you for your response.
I'm getting the date value from a basic date and time attribute on a page. I then use a json structure and an export mapping to export this to a DateTime attribute. My export mapping produces the following for the datetime value in the request body: "inceptionDate":"2021-03-15T00:00:00.000Z"
However in this mapping I don't want to send the milliseconds. Do you know how I can resolve this?
Many thanks.