Between dates

[RushiShroff]

I want to search records by date from some date to
some date.
So select * from tblnm where Insertdt > xxdate.. and
Insertdt < yydate

Is the right approach ?
Or better approach is there ?

Rushi Shroff

 

[RushiShroff]

Also my query is not fetching desired results..
Access 2000
Account_Created_Date datatype &quot;DateTime&quot;

select Account_Created_Date from AccountReport where Account_Created_Date < 2/20/2002

Does anybody know the answer why ??





Rushi Shroff