Time filtering in the slice table

Hi;

AND(MONTH([Date])=MONTH(NOW()), YEAR([Date])=YEAR(NOW()))

With this formula, I can filter the records of that month in the “slice” table.

My goal; How should I use the formula to filter the records in 30 days before today?

Thanks

Try this:

DAY([Date]) + 30 >= TODAY()
2 Likes

Arithmetic expression ‘((DAY([Date])+30) >= TODAY())’ does not have valid input types,

I get this error

It’s totally my bad, do apologize. It shall be like this:
[Date] + 30 >= TODAY()

2 Likes