RobinWosje
4 years agoQrew Member
Filter in Report using Time Period Filter
Hi! Our company has two week time periods. Thanks to this community, I was able to figure out how to create a simple Time Period Formula as follows: FirstDayOfPeriod([Date], Weeks(2), Date(2021,5,19)), but then when I use it to try and filter in the report, I am struggling.
Right now, I just put in the start date of the period and the end date of the period (see below), but this would, of course, require us to go into the report every new pay period and adjust the dates. How do I automate the report so that it always pulls up the current time period?
Thank you in advance!
Robin
------------------------------
Robin Wosje
------------------------------
Right now, I just put in the start date of the period and the end date of the period (see below), but this would, of course, require us to go into the report every new pay period and adjust the dates. How do I automate the report so that it always pulls up the current time period?
Thank you in advance!
Robin
------------------------------
Robin Wosje
------------------------------