In the workflow, I updated the Change Request Table with the value of last working day in Delay_Date column, expectation is to have a delay until it equals the fulfillment date. But still the workflow is getting through with the fulfillment phase.
Question is apart from Change Request Table, do we need to update the delay date in any other tables?
The sql query should return a date value as mentioned...
You can change the query to convert that string to date like below if you know the format will be like 'DD-MON-YY'.. Note that the column should hold the date value by the time delay node executes...
select to_date(LastWorkingDay, 'DD-MON-YY') from pv_users where user_id = '${access_request_cri_meu_userId}'