Filtering by 'Today'

[Matt_Sayward]

Hi, I have a view in one of my bases with a date field called ‘Live Date’ and a filter that’s defined as ‘Where “Live Date” is “today”’.

I would expect that each day I would open this view, the records in the view would reflect the day’s date.

However, this is not the case - the records that stay in the view are those that were marked as ‘today’ on the day the filter was created.

This makes it difficult to use Airtable for to-do management as you have to remember to clear the filter and remake it. It’s also challenging when the person using the database isn’t the one who made it and that person only has a read-only permission.

This seems inconsistent with other filter behaviours - for example on when filtering on single selects records will move in and out of the base automatically.

[Kira_Lapin]

The same airtable problem: my wife and my friend’s Design Studio (20 employees).
They use airtable for projects and tasks.

[Elias_Gomez_Sai]

I still don’t get what you need. Why something like this does not work?

https://airtable.com/shrTISlGxKheGQyGQ

Of course you could add a Status field (or Done field), and filter also by it.

[Kasra]

Hi,

We’re investigating this issue—it should be automatically updating the visible records in the view without the need to change filters, so there’s a bug.

Thanks,

Kasra

[Justin_Murray]

Any word on this yet?

[Michael_Hastie]

Looks like this is still a problem. Any update?

[Kasra]

We improved time-based filters in September to fix some of these issues.

Please email support@airtable.com if this issue is still happening for you so we can investigate more closely. Thank you!