find date

The following statement cant select the date i want in asp programme,how can i solve this problem??how the change the date to date format???Thx for help

Select * from [non residential 2004] where (cancel is null or cancel <> '1') and ([Rollout Month] between 1/1/2004 and 1/31/2004)

Hi

What database solution are you using?

MK

hi

try this out.
please let me know whether this is working.

Select * from [non residential 2004] where (cancel is null or cancel <> '1') and ([Rollout Month] > to_date(1/1/2004) and ([Rollout Month] < to_date(1/31/2004));

i have given the sol but forgot the put hte quotes within the dates. updated query is

Select * from [non residential 2004] where (cancel is null or cancel <> '1') and ([Rollout Month] > to_date('1/1/2004') and ([Rollout Month] < to_date('1/31/2004'));

please let me know whether this worked out.