display records from a query

  • Thread starter Thread starter davey
  • Start date Start date
D

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?
 
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
 
Back
Top