prob in date comparison in access

[nilesh parmar]

hi,
i have access database storing date values as datatype string
no i want record of dates between 2 dates
i mean
select * from table where (adate) between '20/03/2004' and '02/04/2004'

some times this workds but it compares only first 2 characters above
result gives record with date more than 20.

i tried saving data in dat/time format and then executed query but gives
no result.

i also tried with
select 8 from table where adate>'20/03/2004' and adate<'02/04/2004'

thanx in advance for help
nilesh

 

[Frank Kabel]

Hi
you may post this question to one of the MS Access NGs