Date Formula needed for report filter
Report needs to be filtered to product this result (in English) is: If [HANG DATE] is 6 weeks (based on 7 day week) prior to today or [HANG DATE] is blank AND [PROJECTED START DATE] is today o...
Forum Discussion
Hi there BuildPro!
There are a couple of ways to arrange the report filters to accomplish this; but if we want to be specific with the days (where the "Previous 6 weeks" starts as of yesterday and not the beginning of the week) this would be an example of what your report filters would look like
------------------------------
Manny De La Cruz
Customer Adoption Manager
Quickbase
------------------------------
There are a couple of ways to arrange the report filters to accomplish this; but if we want to be specific with the days (where the "Previous 6 weeks" starts as of yesterday and not the beginning of the week) this would be an example of what your report filters would look like
------------------------------
Manny De La Cruz
Customer Adoption Manager
Quickbase
------------------------------
Thank you. Perfect.
------------------------------
BuildPro
------------------------------
------------------------------
BuildPro
------------------------------