Using today formula in bases

Help
1

First, search the help docs and this forum. Maybe your question has been answered! The debugging steps can help, too. Still stuck? Delete this line and proceed.

What I’m trying to do

I am trying to create a simple dynamic view filter in BASES that just displays the files that were created during the last 7 days

Things I have tried

I tried comparing date(file.ctime) to date(today) but could not find any variation that worked.
I even worked with Claude Code. but even that magicical could not find a solution, we experimented for abot 1 hour, but it gave up on me. Anybody else maybe that can help me ?

1 Like
2

I even tried comparing to a property date field (datum) that i add to every note I create (YYYY-MM-DD) but unfortunately no results either.

3

I just found a solution. The filter should be: (today()-datum).days.round()<=7
Got some inspiration from a YouTube by Antone Heyward