compare the existing date below with current date

[vnn2492]

Notification should send when a ID has been stuck at any of the following type of errors raised, should send an email if the error is stayed  48 hours+, need to exclude weekends

Year	ID	error  Vault	type of error	Changed On
2020/21	1221	error	system error	24/09/2021 18:00
2020/21	2341	error	output error	27/09/2021 11:35
2020/21	3456	error	system error	28/09/2021 10:20

[mceleavey]

Hi @vnn2492 ,

I've attached the solution.

You basically have a calculation that calculates the difference in hours between the "Changed On" field to the current datetime. I've calculated this separately to show you the hours difference, then applied a filter to split into those you wish to email and those which are not yet old enough.

You would then maybe build a table and send this as the body of the email.

Hope this helps,

M.

[vnn2492]

Thank you for your response, I was looking for even to exclude weekends while calculating 48 hours, i.e., we should not consider weekends when calculating from "changed on" field to current date time 

Thanks

[binay2448]

Please find attached workflow, may be it can help you.