Skip to main content
Question

Date Formula needed for report filter

  • September 21, 2021
  • 0 replies
  • 25 views
Forum|alt.badge.img+11
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 or within the next 2 weeks

thank you


------------------------------
BuildPro
------------------------------

  • MannyDeLaCruz
  • Quickbase Staff
  • September 22, 2021
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
------------------------------
Terms & ConditionsAccessibility statement