How to compare date in MS ACCESS using Sql SELECT.. WHERE..BEETWEEN ... AND?

Question

Tried this, but 0 record is returned.
SELECT *
FROM
Item_issue
WHERE date_issue BETWEEN 01/06/2007 and 07/06/2007
ORDER BY Name_item desc

And i'm gonna use it in VB .. TQ

Answer 1

In Access, dates are delimited with hashes (#) and the BETWEEN predicate does not always work as expected.



SELECT *

FROM Item_issue

WHERE date_issue >= #01/06/2007# AND date_issue <= #07/06/2007#

ORDER BY Name_item DESC

Answer 2

For practice using SQL commands in MS Access: Etc.. (see link below. I hope this helps.)

Answer 3

attempt to transform them to unix timestamp format (style of seconds from January 1st, 1970). there might desire to be a function that does this for you (and lower back from it). then the assessment is ordinary, you basically learn integers, and you may actually do date manipulations (ie a million day = 86400 seconds)