Hi guys
I have a query where I was usingto pull all records for the prior month, it worked find until they changed the date from mm/dd/yyyy to yyyy-mm-dd, I can't seem to find the right code to pull up the correct records.
Please Login or Register to view this content.
Last edited by AccountingJ; 05-14-2020 at 12:14 PM.
Try using...
Please Login or Register to view this content.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
I get the "Data Type Mismatch in Criteria Expression" error. I looked at the table and the data type is "Short Text" instaed of Date/Time... and it won't allow me to change it
Short text... so you can't use numeric comparison operator.
What you can do is use SQL side query to convert column then use numeric operator on the expression.
Something like below, assuming it's MS Access.
EDIT: 'can' should be can't in first sentence. Fixed.Please Login or Register to view this content.
Last edited by CK76; 05-14-2020 at 11:04 AM.
thank you, this helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks