Help

Lines of the last week

Topic Labels: Formulas
Solved
Jump to Solution
1622 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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

 

Thanks a lot, you are a machine !