How to deal with a Datetime type value passed from a Flow and process it using the DATETIMEVALUE(dateInput) formula in Data Processing Engine

By default, DATETIMEVALUE(dateInput) formula is expecting the date to be in the format "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" with milli seconds. However, the DATETIMEVALUE method in Data Processing Engine (DPE) is internally translated to to_timestamp method which can accept two params: datetime (mandatory) and format(optional): to_timestamp(field,'format(optional)').

Therefore, when receiving a Datetime type value from a flow and the data format is passed in the format yyyy-MM-dd'T'HH:mm:ss'Z', please use the format DATETIMEVALUE({$dateInput},"yyyy-MM-dd'T'HH:mm:ss'Z'").