Is it possible to manipulate the date formatting in an escalation email node?
By default it outputs Date and Time down to a tenth of a second. Obviously this is not a great end user experience...
Wokflow Email Node:
Email Output:
Thanks,
Bill
v7.0.1 P02_HF08
In your escalation workflow, you can add a SQL Select node and manipulate the review start/end date value. Place "new" value into a workflow variable and then use that variable in the email node.
Are you aware of which database attribute holds the date the review is activated? Now that I'm digging into this, I am realizing that the out of box "Start Date" is pulling the review creation date, which is not always the same if you have the review on hold for any amount of time. I found an "Active Date", but it is null for one of my Active Reviews (Select Active_Date From T_AV_REVIEWS)
UPDATE: I was able to find the review activation date writing some clever SQL against the T_AV_REVIEW_HISTORY table.
In your escalation workflow, you can add a SQL Select node and manipulate the review start/end date value. Place "new" value into a workflow variable and then use that variable in the email node.