Filtering for the last x days

I have a formula like [Date property] > (Today() - 21)
The expected behaviour is to filter the last 21 days but instead it filters only the last 19 days.
Where I made the mistake?

I just whipped this up and it seems to be working… i also added in dates after today just to get exactly what you were looking for.

[date property] >= today() - 21 AND [date property] <= today()

That gave me 22 dates in all

Hope this helps!

1 Like

This gave me 18 days, instead 22 :wink:
To get 21 days I must use " > Today() - 25".
For some reasons its not working as expected… crazy.

interesting, I’m glad you were able to get it to work though!