I have an application that handles schedule for installation of garage doors...I would like to put together a report that shows all jobs that were installed exactly 1

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have an application that handles schedule for installation of garage doors...I would like to put together a report that shows all jobs that were installed exactly 1 year ago...Maybe even one that shows for the entire week...It will allow for us to pull the report and have one of my office workers followup and call each one to see if they needed service.  Any suggestions on how to do that filter?
Photo of Ty

Ty

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
I suggest creating a formula checkbox field called [Same week last year?]

FirstDayOfWeek(Today()) = FirstDayOfWeek([Installation Date]+Weeks(52))

Then use that as you report filter. Then you will have a whole week to get those calls done before the report changes.