I had a database where I used this criterion to get only information between the indicated date. It looked like this: BETWEEN #01/01/2021# AND #12/31/2040# I screwed up that database, so I am trying to rebuild my queries. this function as typed will not work. I don’t know what I am doing wrong. Please help.
Thank you, I did figure out that I hadn’t set the field to dates, hence my criterion wasn’t working. However, now that I have it working, is there a limit as to how far out I can set dates? I have a few that have the set date of 2040, but when I run the query, those people don’t show up on the list. I can’t think of any other reason it wouldn’t pick up the ones set at 12/31/2040. I am running the latest version of the software.