Skip to main content
Question

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

  • February 8, 2018
  • 0 replies
  • 43 views
Forum|alt.badge.img+6
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!
    This topic has been closed for replies.

    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.
    Forum|alt.badge.img+6
    • jrossausiscom
    • Author
    • Registered
    • February 8, 2018
    Awesome!  I will give this a test and report back it if works or explodes.
    Forum|alt.badge.img+6
    • jrossausiscom
    • Author
    • Registered
    • February 8, 2018
    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.
    Forum|alt.badge.img+6
    • jrossausiscom
    • Author
    • Registered
    • February 8, 2018
    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

    :)
    Terms & ConditionsAccessibility statement