I am used to doing queries between 2 dates. Dates are usually stored in short date format from the Date() function
I have a new project that stores TransactionDate as Date/time type. Generated with Now() function to record the time as well as the date.
Now when I try to filter between 2 dates it doesn't filter properly (shows all records). I thought it was because I am picking up the date parameters from a form that has date controls formatted as short date.
I've tried converting to short date format in the query first but same result.
I think I'm missing something basic.
JON
I have a new project that stores TransactionDate as Date/time type. Generated with Now() function to record the time as well as the date.
Now when I try to filter between 2 dates it doesn't filter properly (shows all records). I thought it was because I am picking up the date parameters from a form that has date controls formatted as short date.
I've tried converting to short date format in the query first but same result.
I think I'm missing something basic.
JON