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
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!