BETWEEN and AND not returning results

[Nelmo]

I have a query that uses the BETWEEN and AND criteria in a DATE field to filter the records.
I have a record that is dated 08/10/03.
If I type that as the Start and the End date the query returns no records.
If I type Between 07/10/03 and 09/10/03 the query returns the record.
???????????

Can anyone help please?

Nelmo

 

[ColinEssex]

Check that the date field is set to short date.

Col

 

[Nelmo]

Thanks Colin

I checked the properties of the field, they were Short Date.

However, I also had code running behind a 'New' button that added todays date into the date field and used Now() instead of Date().

Problem sorted


Thanks