How to create a date condition in Airtable module

How To
, ,
1

Hello there, I am trying to set a filter based on publications created in the last seven days. Here is how I set my configuration, obviously wrong, can anyone help please ? :folded_hands:

image
image787×599 52.5 KB

2

Hi Vanessa,
Instead of typing DATEADD, select the dedicated function available in the Make date functions menu: Date and time functions - Help Center

The correct function you could use here is addDays(). When correctly selected, it will display as a token

3

Hi Vanessa,
you can use the following formula to filter data from Airtable using the date:

  • For date and time: {{addDays(now; -7)}}
  • If you’re checking only the date (without time): {{formatDate(addDays(now; -7); "YYYY-MM-DD")}}

Note: Be sure to modify the format to match the format of your Airtable column.

3 Likes
4

thanks for your help @proboticsolutions wish you a nice day ! :slight_smile:

2 Likes