Date Formula needed for report filter

Question

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
------------------------------

mannyde_la_cruz · Answer

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 CruzCustomer Adoption ManagerQuickbase------------------------------

buildpro · Answer

Thank you.&nbsp; Perfect.------------------------------BuildPro------------------------------

Forum Discussion

Date Formula needed for report filter