JeremyLahners
3 years agoQrew Cadet
Report filtering Date since last business day
I'm trying to create a table report that only shows records that have had specific date fields modified since the last business day. I added a Report Formula to the report however the filters are not allowing me to select that as a criteria to compare against.
The formula I added is:
ToWeekdayP(Today()-Days(1))
I had hoped to add filters like:
Date1 is after <report formula>
Date2 is after <report formula>
Am I missing something (entirely possible) or has someone solved for this problem in a better way?
------------------------------
Jeremy Lahners
LeadBaller
------------------------------
The formula I added is:
ToWeekdayP(Today()-Days(1))
I had hoped to add filters like:
Date1 is after <report formula>
Date2 is after <report formula>
Am I missing something (entirely possible) or has someone solved for this problem in a better way?
------------------------------
Jeremy Lahners
LeadBaller
------------------------------