Filter in Report using Time Period Filter

Question

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

MarkShnierYou · Answer

no problem.Just make a formula checkbox field called [Date is in the Current Period?] FirstDayOfPeriod(Today(), Weeks(2), Date(2021,5,19)) = FirstDayOfPeriod([Date], Weeks(2), Date(2021,5,19))In other words if the first day of the period of today matches the first day of the period of the particular date field then the date field must be in the same time period as today.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community