Discussions

 View Only

Report filtering Date since last business day

  • 1.  Report filtering Date since last business day

    Posted 08-08-2022 10:41
    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
    ------------------------------