How to filter data's date field by current date

Ask the community
1

Hey everyone, I was wondering if there’s any way to display a list of records from Airtable that only shows records where today’s date matches a date field, or where today’s date falls between 2 date fields. Is that possible?

2

Perhaps use a view in airtable to filter by dates as required, and then select that view for your list block

3

Thanks for the suggested workaround. Trying to filter by Today’s date in Airtable isn’t quite straightforward so I was hoping there was a way to filter somewhere between Airtable & Softr. Instead of filtering by a preset date, there’d be a way to filter by date.today or something along those lines.

1 Like
4

Hi team, do we have a solution to this? Reviving the topic

5

Solved: the below formula buckets the dates into
today, tomorrow, this weekend and Other

IF(
DATETIME_FORMAT({Date},‘MM/DD/YYYY’) = DATETIME_FORMAT(TODAY(),‘MM/DD/YYYY’), ‘Today’,
IF(
DATETIME_FORMAT({Date},‘MM/DD/YYYY’) = DATETIME_FORMAT(DATEADD(TODAY(),1,‘days’),‘MM/DD/YYYY’), ‘Tomorrow’,
IF(
AND(
DATETIME_DIFF(DATEADD(TODAY(), ‘days’, 5), {Date}, ‘days’) <= 2,
DATETIME_DIFF(DATEADD(TODAY(), ‘days’, 5), {Date}, ‘days’) >= 0
), ‘This weekend’, ‘Other’
)
)
)

6

How to use this code?