Forum Discussion

jrossausiscom's avatar
jrossausiscom
Qrew Assistant Captain
8 years ago

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

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!
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.
  • jrossausiscom's avatar
    jrossausiscom
    Qrew Assistant Captain
    8 years ago
    Awesome!  I will give this a test and report back it if works or explodes.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    I suggest making an actual formula checkbox field. Then use that field as a filter in the report.
  • jrossausiscom's avatar
    jrossausiscom
    Qrew Assistant Captain
    8 years ago
    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

    :)