Retrieving data between two dates in Access

[sonalpathak]

hi!
i ve been using this query in ACCESS n its nt working:
SELECT * FROM TABLENAME WHERE BDAY BETWEEN '01/01/1980' AND '01/01/2006';
the error is "Datatype mismatch in criteria expression'.

[Rabbit]

Use:

SELECT * FROM TABLENAME WHERE BDAY BETWEEN #1/1/1980# AND #1/1/2006#

[NeoPa]

This link (Literal DateTimes and Their Delimiters (#).) may help you understand the situation better (Why Rabbit's solution works).