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))...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendno 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Came to the forum looking for an answer to a similar question today. I suspected there would be a perfect Mark Shnier response if I just looked hard enough.
Thanks again for your contributions to this forum, Mark.
------------------------------
Rick Putnam
------------------------------
Thanks again for your contributions to this forum, Mark.
------------------------------
Rick Putnam
------------------------------