Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

compare the existing date below with current date

vnn2492
7 - Meteor

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 On
2020/211221errorsystem error24/09/2021 18:00
2020/212341erroroutput error27/09/2021 11:35
2020/213456errorsystem error28/09/2021 10:20

 

3 REPLIES 3
mceleavey
17 - Castor
17 - Castor

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.

 

mceleavey_0-1634660705493.png

 

mceleavey_1-1634660729498.png

 

 

Hope this helps,

 

M.



Bulien

vnn2492
7 - Meteor

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
11 - Bolide

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

Labels