Hello,
We have defined a custom Review Escalation WF to send escalation emails. There is a variable in the email node of the WF like '${review_rvw_due_date}' which retrieves the duration date of the review.
The problem is that we can not change the date format of this variable. It seems the default date format of the WF editor is 'YYYY/MM/DD' however we want to change it as 'DD/MM/YYYY'
Is anyone have an idea to make this change?
We use VIA 7.0.1 P02
Hi Adem,
Can you try adding a SQL Select node before the email node to convert date format of the variable to DD/MM/YYYY. you can use the below query in the SQL select statement.
select to_char(to_date(${review_rvw_due_date},'YYYY/MM/DD'),'DD/MM/YYYY') from dual;
Regards,
Sabthami Subramanian