HansHamm
5 years agoQrew Assistant Captain
Subscription
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
------------------------------
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
------------------------------