Hi All,I am getting an error while formatting the date in Get Rows module of action Flow.I am using below syntax{{formatDate("SALES_ORDER.REQUESTED_DELIVERY_DATE"; "DD.MM.YYYY")}}

Hi Ayushi,

please check the column type of field REQUESTED_DELIVERY_DATE.

In case it is a STRING try to convert it into a date first within Get rows module.

E.g PQL formula in Get Rows for field REQUESTED_DELIVERY_DATE

TO_DATE ( "SALES_ORDER.REQUESTED_DELIVERY_DATE", FORMAT ( '%Y-%m-%d ) )

But this is only working if the field is a STRING and in case the STRING values looks similar to:

e.g: '2017-03-14 11:22:33'

BR

Dennis