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.
Page 1 / 1
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.