display records from a query

[davey]

i have created a expression in a query to calculate a date one year on.
i am trying to enter a criteria to show the records between two dates.
i have tryed between[start date]and[end date].
if i enter 01/04/2009 and 30/04/2009 to show the records for april it
returns the records from January to the end of April.
why will it not reconize the start date?

 

[John Spencer MVP]

Probably because it is recognizing the dates you are entering as US format
dates. You can try entering the dates in the format yyyy-mm-dd as that is
always understood.

See the following article by Allen Browne that discusses the problem and
solutions.
International Dates in Access at:
http://allenbrowne.com/ser-36.html

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County