All:
I'm trying to filter a query with the between function, however there's something wrong with the date format that makes its implementation bring up the following error:
"This expression is typed incorrectly, or it is too complex to be evaluated."
I had to derive the date from a longer string. My ODBC connection table returned an entry formatted as "yyyy-mm-dd hh:mm:sss - 05:00"
In order to get the date, I used the left function, format function and CDate function:
CDate(Format(Left(dtoDateConsumed, 10), "mm/dd/yyyy"))
I then put this entry into another query and in the criteria section I have:
Between [start date] and [end date]
How do I make this query work?
Thank you in advance for any help.
I'm trying to filter a query with the between function, however there's something wrong with the date format that makes its implementation bring up the following error:
"This expression is typed incorrectly, or it is too complex to be evaluated."
I had to derive the date from a longer string. My ODBC connection table returned an entry formatted as "yyyy-mm-dd hh:mm:sss - 05:00"
In order to get the date, I used the left function, format function and CDate function:
CDate(Format(Left(dtoDateConsumed, 10), "mm/dd/yyyy"))
I then put this entry into another query and in the criteria section I have:
Between [start date] and [end date]
How do I make this query work?
Thank you in advance for any help.