Skip to main content
Question

Previous Work Day

  • February 19, 2024
  • 0 replies
  • 97 views

I have a very simple problem that seems to be more complicated than it should be. I have a report that I would very simply like to report on the previous day. This works fine from Tues-Fri, however, when it comes to Monday it needs to be manually adjusted for Friday. QB does not seem to have work days built into the date field.

I've tried a few report formulas which can display the previous work date just fine. Though I cannot for the life of me figure out a way to filter the report on that date. Another option would be to somehow make a formula that shows the number of days in the past that the previous work day occurred.

Any help would be much appreciated.



------------------------------
Cody Mckelvey
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    How about a formula checkbox field called [Previous Day?]

    [My Date Field] = ToWeekdayP(Today())

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    ToWeekdayP (Date d)

    Description: If the given date d is a weekday returns it, otherwise returns the previously occurring weekday.

    Example: ToWeekdayP(ToDate("6/21/2003")) returns 6/20/2003



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement