Skip to main content

Error: The operation failed with an error. Failed to map '0.columnName': Function 'formatDate' finished with error! 'SALES_ORDER.REQUESTED_DELIVERY_DATE' is not a valid date.

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

 


Reply