Hi there. Has anyone figured out how to filter records in Interfaces for current week? I want to summarize values for this ongoing week and don't really know how right now. Thanks!
Solved
Filter records by current week
+21Best answer by Rupert_Hoffsch1
OK, I was a dumb***. Of course we can still use formulas and have a formula calculate if it is the current week.
IF(WEEKNUM(NOW()) = WEEKNUM(Date), 1, 0)
+4The only way I have been able to do this was to create a filter with 2 conditions. one that has a Starts on or after x date and another that starts on or before x date.
+21The only way I have been able to do this was to create a filter with 2 conditions. one that has a Starts on or after x date and another that starts on or before x date.
Thanks. But the date you're comparing to is not dynamic, right? So the user has to set the current week, it's not automatically assigned by Airtable.
+21OK, I was a dumb***. Of course we can still use formulas and have a formula calculate if it is the current week.
IF(WEEKNUM(NOW()) = WEEKNUM(Date), 1, 0)
OK, I was a dumb***. Of course we can still use formulas and have a formula calculate if it is the current week.
IF(WEEKNUM(NOW()) = WEEKNUM(Date), 1, 0)
But does the table update itself? So it puts all of the numbers to 0 that were 1 previus week?
+21But does the table update itself? So it puts all of the numbers to 0 that were 1 previus week?
Yes 🙂 Airtable formulas are instantaneous
Yes 🙂 Airtable formulas are instantaneous
I found a problem with this tacric so when a new year starts You will have 2 weeks with the same week number.
+21I found a problem with this tacric so when a new year starts You will have 2 weeks with the same week number.
You mean that different years can span across the same week?
You mean that different years can span across the same week?
Yes so next year when the same week comes you will have this week and the same week from a year ago both labeled with 1. Hope that makes sense
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.