- Local time
- Today, 17:45
- Joined
- Sep 12, 2006
- Messages
- 16,044
Is this sorted now?
Maybe the issue is trying to treat the date as a text string
if the dates fields were defined as dates. then presumably the values would be #9/1/2020# and #8/31/2021#
Something like that. I assume the OP is in the US, or at least some somewhere where #9/1/2020# is "September 1", rather than "9 January"
Maybe the issue is trying to treat the date as a text string
if the dates fields were defined as dates. then presumably the values would be #9/1/2020# and #8/31/2021#
Something like that. I assume the OP is in the US, or at least some somewhere where #9/1/2020# is "September 1", rather than "9 January"
