Previous Work Day
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, ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHow 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
------------------------------
I guess some more context is there is a field in our DB tracking all activity on a given day. We report on the previous day that the specified activity took place. This is fine all circumstances besides Monday, as the previous date for Monday is Sunday. I'm not quite sure how to utilize the checkbox to achieve this? Apologies, I'm not too familiar with the report formulas.
------------------------------
Cody Mckelvey
------------------------------- MarkShnier__You
I'm suggesting that you make a real field of type formula checkbox. Then make a report that users that field as a Dynamic Filter, or as the report filter if you just want a report for the previous business day.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
