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

 

[NuBie via AccessMonster.com]

why will it not reconize the start date?
Actually it did!

perhaps your computer is not as smart as you think. maybe your pc is confused
with your date settings and it interpreted "01/04/2009" as January 04, 2009.
(instead of April 01, 2009). Thus your query returns records from January to
April.

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?