How could I filter all records on Weekend days (Sat and Sun only)?

  • 0
  • 2
  • Question
  • Updated 1 year ago
  • Answered
I need to filter a report of ours to only show records created ON all Saturdays or Sundays of the month.  How do I go about this?

Thanks!
Photo of John Ross

John Ross

  • 662 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 2
no problem

Make a formula checkbox field called [Record was created on a weekend?]

DayOfWeek(ToDate([Date Created])) = 6 // Saturday
or
DayOfWeek(ToDate([Date Created])) = 0 // Sunday



Then you can make a report to filter on that field.

The Day of Week function returns the day number of the week and Sunday is day zero.  Monday is day 1.  etc.
Photo of John Ross

John Ross

  • 662 Points 500 badge 2x thumb
Awesome!  I will give this a test and report back it if works or explodes.
Photo of John Ross

John Ross

  • 662 Points 500 badge 2x thumb
Hm, are you saying to created a calculated column?
I suggest making an actual formula checkbox field. Then use that field as a filter in the report.
Photo of John Ross

John Ross

  • 662 Points 500 badge 2x thumb
So I was able to get what I needed but via a different method somewhat.  I tried using the code provided above but it would always error off when I put in our column name.

I ended up having a calculated column that shows the number of the day, and then told the report to only show 0 or 6

:)