Convert Date format in Mapping

Scenario:

The date created value obtained form saved search is like 30 MAY, 2024 3:52:10 PM. However the value is being set to a system where the required date format is 30-05-2024.

Solution:

Apply the dateFormat handlebars in the mapping as follows to convert the format:

{{dateFormat o/pformat date i/pformat timezone}}

Here the o/p format required is YYYY-MM-DD.

The i/p format is DD MMMM, YYYY HH:mm:ss A

Hence the handlebar expression would be

{{dateFormat “YYYY-MM-DD” [Date Created] “DD MMMM, YYYY HH:mm:ss A”}}