Skip to Content
avatar image
Former Member

Omit the weekend from "Previous Days" search

I built a report to find work that was completed within the past 24 hours and it is scheduled to go to my manager every morning. The problem comes Monday morning when there was no work completed on Sunday. Is there a way to see Fridays work on the following Monday?
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 19, 2017 at 01:55 PM

    You can create a filter to look for previous days:

    =If (DayName(CurrentDate())="Monday") Then RelativeDate(CurrentDate();-2) Else RelativeDate(CurrentDate();-1)

    See if this works for you.

    Add comment
    10|10000 characters needed characters exceeded