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
Hello Adam,
See if following post helps
https://community.rsa.com/thread/188007?commentID=877680#comment-877849
Thanks for your replay Apeksha,
There are 2 suggestions in the post as i can see:
1-) To change the Language and Format from the UI.
2-) To change the standalone.conf file like in below screenshot.
We already checked this solutions but still facing the issue.
Also we have changed the databaseDateFormat from:
Admin>System>Custom
But still have the problem. Do you have any other suggestions?
To be more specific, step 2 is what you really need for this case. Could you give us the output of the following command to verify that changes were added:
ps -ef | grep -DuserHi 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
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