1
Image of the test/error:
I only intend to search the data between a date and another, using:
SELECT * FROM tblTRAZA
WHERE FECMOV >= '2013-01-03'
AND FECMOV <= '2013-01-09';
But I’ve tried other date formats for query like yyyy/mm/dd
, I tried to use only the date without the hours, and as in the image, I tried to use a specific date that I had already registered, but this error haunts me. You may have to change the table date structure?
I broke my head a little and managed to discover the date format used by access here, and it was like this: SELECT * FROM tblTRAZA WHERE (((tblTRAZA.FECMOV)>=#5/30/2014 00:00:00#) AND ((tblTRAZA.FECMOV)<=#5/31/2014 23:59:59#)) BY FECMOV order;
– Hugo L.F.
glad you could. Post as an answer and mark it as resolved so you can help future visitors!
– Joao Paulo