dschomburg
MIS
I use a query based on 2 functions; [FromDate] and [ToDate]. Based on the help file for 'between and....' which states that useing the between function is inclusive. And it is, sort of, but not really.
What I've found is that BETWEEN only is inclusive if there is no time as part of the format. Cuz 1/1/02 is not the same as 1/1/02 12:35 PM
Which stinks cuz this means that all my reports have been slightly off for the past few months.
**If this is not the case, and I'm just doing something else wrong, please let me know.
What I've found is that BETWEEN only is inclusive if there is no time as part of the format. Cuz 1/1/02 is not the same as 1/1/02 12:35 PM
Which stinks cuz this means that all my reports have been slightly off for the past few months.
**If this is not the case, and I'm just doing something else wrong, please let me know.