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

Keep date as date in a field. Why keep dates as strings? A string will be used as a string by any program.

Now, if you keep it as date,
Between #3/4/2004# And #3/5/2004#

your single quotes tell access "treat this as a string".

I notice that you have some type of European date format. Use the Access query builder to write your query. your sintax is wrong. ine would look like this:

SELECT Table1.date1
FROM Table1
WHERE (((Table1.date1) Between #3/4/2004# And #3/5/2004#));







Sal