Return last three days data if today is Monday

stj1120

Hi all,

I need to show the results that are generated on Friday, Saturday and Sunday on monday. Then for the other days from Tuesday to till Friday I need to show the previous day data. 

I tried the below formula but, no luck.

IF DateTimeFormat(DateTimeToday(), "%a") = "mon"
THEN DateTimeDiff(DateTimeFormat(DateTimeToday(), "%Y-%m-%d"),DateTimeFormat([Date],"%Y-%m-%d"),"days")<4
ELSE DateTimeFormat([Date],"%Y-%m-%d") = DateTimeFormat(DateTimeAdd(DateTimeToday(), -1, "days"), "%Y-%m-%d")
ENDIF

Please check and help how to achieve this. 

Thank you.

Best Regards,

Teja.

Alerts.xlsx

New Workflow3.yxmd

AngelosPachis

Hey @stj1120 ,

You can use a filter tool with the following expression 

IF Datetimeformat(DateTimeToday(),"%a")="Mon"
// check if day workflow runs is Monday
 THEN (DateTimeDiff(DateTimeToday(),Datetimetrim([DateTime],"days"),"days")>=1 
AND DateTimeDiff(DateTimeToday(),Datetimetrim([DateTime],"days"),"days")<=3)
//keep previous 1 to 3 days
ELSE DateTimeDiff(DateTimeToday(),Datetimetrim([DateTime],"days"),"days")=1
//keep previous day
ENDIF

Dateteimdiff functions find the days between todays date and  previous days and the Datetimetrim function trims all days to midnight. So today is the 1st of June, but if you had a record for the 31 of May 23:59:50 you would like to show that record because it is in the previous day, although technically 24 hours have not gone by

Hope that helps,

Angelos

example_.yxmd