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! Go to Solution.
It’s totally my bad, do apologize. It shall be like this:
[Date] + 30 >= TODAY()
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()
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |