Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 25, 2023 04:25 AM
Hello and thank you for considering to help me!
Every day, my Airtable is supplied with additional lines through an x bias.
How can I create a view that only collects last week's rows?
I only manage to get the lines from 7 days ago and not all those from last week.
Any idea ? 🙂
Kindly
Solved! Go to Solution.
Oct 25, 2023 06:09 AM - edited Oct 25, 2023 06:14 AM
Hi @Julien_Etoke ,
For example, this formula determines which week the date is compared to today.
SWITCH(WEEKNUM(TODAY())-WEEKNUM({Date}),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)
If you filter this field to show only last week, then that view will always show only last week's records.
When a week begins on Monday, it is like this.
SWITCH(WEEKNUM(TODAY(), "Monday")-WEEKNUM({Start Date}, "Monday"),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)
Oct 25, 2023 06:09 AM - edited Oct 25, 2023 06:14 AM
Hi @Julien_Etoke ,
For example, this formula determines which week the date is compared to today.
SWITCH(WEEKNUM(TODAY())-WEEKNUM({Date}),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)
If you filter this field to show only last week, then that view will always show only last week's records.
When a week begins on Monday, it is like this.
SWITCH(WEEKNUM(TODAY(), "Monday")-WEEKNUM({Start Date}, "Monday"),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)
Oct 25, 2023 09:27 AM
Thanks a lot, you are a machine !