compare the existing date below with current date

Question

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 IDerror  Vaulttype of error Changed On2020/211221errorsystem error24/09/2021 18:002020/212341erroroutput error27/09/2021 11:352020/213456errorsystem error28/09/2021 10:20

binay2448 · Answer

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

old errors_bk.yxmd

vnn2492 · Answer

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

mceleavey · Answer

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.

old errors_mceleavey.yxmd