Dates driving me crazy

[hbrems]

A classic problem:

I'd like to retrieve records between txtstartdate and txtenddate. For example all records between 04/11/2007 and 06/11/2007.

Easy enough, if Access wouldn't always want to change the formatting to mm/dd/yyyy instead of dd/mm/yyyy.

How can I resolve this issue?

Kind regards,
Hans B.

 

[Brianwarnock]

I suspect that you are using the popup prompt box to enter the parameters, try using a form to enter them instead, I always use a form and have no problems,

Brian

 

[Gethzerion]

I seem to recall if you are using an SQL statement to store dates, you need to use the DateValue function to store them correctly - ie so they don't change to US format.