Hello,
The workflow I am designing requires an email to be sent after a certain time spent in a step. Is this possible using the Date Diff function?
Hello,
The workflow I am designing requires an email to be sent after a certain time spent in a step. Is this possible using the Date Diff function?
Hi,
You can extract this data from table WFD_EnterToCurrentStepDate
SELECT
WFD_EnterToCurrentStepDate,
DATEDIFF(DAY, WFD_EnterToCurrentStepDate, GETDATE()) AS DaysElapsed
FROM
wfelements
WHERE
wfd_id = 102711
Regards.
Hi Simon,
I'm not sure whether you actually need the date diff function.
Are you aware of the Timeout concept?
https://docs.webcon.com/docs/2023R3/Studio/Workflow/Step/Actions/Action_Timeout/
One use case of these is to send "reminders" after x minutes/days/weeks.
The only caveat is, that it uses the step entry date. If you have any paths on this step, which lead to the same step, the step entry date is updated.
I've described it here in more detail and I noticed I used the reminder as an example.
https://daniels-notes.de/posts/2021/unified-save-experience#differences-between-the-save-button-and-a-save-path
Best regards,
Daniel