Yesterday Date but ignoring Sunday

[tf05]

I have a formula set up that indicates yesterdays data in the output. On a Sunday no data is recorded and therefore on Monday this returns no data. Is there a way I can put in an exception which on Monday ignores Sunday and returns Saturday as 'Yesterday'

Currently I have a formula creating a field with yesterdays date  DateTimeAdd(DateTimeToday(),-1,'day')

and then filtering if [Date] = [Yesterday Date] 

[atcodedog05 · Accepted solution]

Hi @tf05 

Here is the formula for yesterday where Sunday is excluded.

IF DateTimeFormat(DateTimeToday(),"%w")="1" THEN 
DateTimeAdd(DateTimeToday(),-2,"days")
ELSE 
DateTimeAdd(DateTimeToday(),-1,"days")
ENDIF

Hope this helps : )

[atcodedog05]

Happy to help : ) @tf05 

Cheers and have a nice day!