Urgent : Date Comparison Problem

[RushiShroff]

I am firing the query
Access 2000,dtfield is DateTime field..

select * from tblnm where dtfield < mm/dd/yyyy

It is not fetching the correct results
where as

select * from tblnm where dtfield > mm/dd/yyyy
works fine.
Also
select * from tblnm where dtfield < now()
works fine.

Just tell me if you know.

Rushi Shroff

 

[webspy]

use this type of query
instead of using dd/mm/yy u can use dd-mmm-yy
because the date type is mostly dipends on system date type so for the safe use dd-mmm-yy format
so try this query
select * from tblnm where dtfield < mmm-dd-yyyy

happy programming
raghu

 

[RushiShroff]

What is this mmm(Triple)?? Rushi Shroff Rushi@emqube.com
&quot;If freedom is short of weapons,we must compensate with willpower.&quot;-Adolf Hitler

 

[webspy]

dd- date
mmm -month format
yyyy - year format
like jan-12-2002,feb-12-2002