Skip to main content

Skip the weekend

  • December 18, 2021
  • 1 reply
  • 12 views

I’m looking for a way to set the filter to only show the next workday.

I’m a teacher [primary school] and each day we have a ‘topic of the day’. That topic is introduced by me the day before by a riddle. Because i would like parents at home to talk to their children about this riddle (and try to guess the topic together), I made a base with all topics, their riddles and the dates i will talk about them.

I’ve made a ‘view’ with a filter ‘where -date- is tomorrow’, but on fridays this doesn’t work as it has to show the riddle for the topic on monday (there is no topic/riddle on saturday).

I’m only using Airtable for a few months now so maybe the solution is simple…

Any help would be appreciated!!

This topic has been closed for replies.

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • December 18, 2021

You could create a formula field with WORKDAY_DIFF() and TODAY() and your date field. Then filter on the result.