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.