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

  • 642 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
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

  • 642 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

  • 642 Points 500 badge 2x thumb
Hm, are you saying to created a calculated column?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
I suggest making an actual formula checkbox field. Then use that field as a filter in the report.
Photo of John Ross

John Ross

  • 642 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

:)