Let's say you just want to see the current day's  / week's / month's / year's results. 

Simply create a new column and use one of the following expressions:

now().startOfYear() == my_column.startOfYear()
now().startOfMonth() == my_column.startOfMonth()
now().startOfWeek() == my_column.startOfWeek()
now().startOfDay() == my_column.startOfDay()

*where my_column is your date column. 

The result will be true of false

Next, click the filter button and filter by column = true


Have a question? 🧐

We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor's interface.

Did this answer your question?