I don't think so. I think it is doing a valid mathematical computation (just not the one you want).Interesting. Can only imagine that the date being passed is null or an empty string, which would explain it. However, I would have expected a syntax error instead.
This seems to be working for me as I have been able to isolate records related to each quarter in a year using between ,and, > , < operatorsI don't think so. I think it is doing a valid mathematical computation (just not the one you want).
10/1/2020 would read as 10 divided by 1, which would be 10, and then divided by 2020, which would be: 0.00495.
Since Excel and Access store dates as the number of days since 1/0/1900, that would be a time on that date.
So any date after 1/0/1900 wou;d evaluate as TRUE, and be returned.
Yes, it works properly when you use the date qualifiers of "#".This seems to be working for me as I have been able to isolate records related to each quarter in a year using between ,and, > , < operators