Skip to main content
Question

Subscription

  • April 14, 2020
  • 0 replies
  • 20 views

Forum|alt.badge.img+8
On every Thursday I am wanting a report to be emailed out to the field managers for their associates per diems for the coming week.
Hotel Check-In Date Is On or Before 9 Days in the future - 
Hotel Check-Out Date Is On or After 5 Days in the future - 
This drills down to the upcoming week...

The question is;
Will these two Report Filters set for (Date is On or Before) and( Date is On or After) move incrementally each week when the report is "fired" on Thursdays?
Meaning Report is fired on 04.16.2020 and the Before and After Dates would be 04.25.2020 and 04.19.2020
Report is fired on 04.23.2020 and the Before and After Dates would be 05.02.2020 and 04.26.2020
etc...

Thanks in Advance!

------------------------------
Hans Hamm
------------------------------
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
Yes! They will adjust based on the day the reminder is sent (or technically whatever day anyone looks at the report).

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------