Skip to main content
  • Home
  • Community
  • Product Q&A
  • Process Improvement
  • 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")}}

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


Terms & ConditionsCookie settings