Time filtering in the slice table

Pointer
Participant V

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

Solved Solved
0 3 171
1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3

LeventK
Participant V

Try this:

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

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()

Top Labels in this Space