Yesterday Date but ignoring Sunday

Question

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 Answer

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 : )