british date reverting to us date

[lee12]

I have a database that is designed to run with british regional settings. Everything works fine except for one form that uses some vb code to process a range of dates. All entries from this form are converted to us format, i.e. if I enter 03/01/03 to 10/01/03 instead of getting 3rd to 10th Jan I get the 3rd day of each month Jan to Oct. I have seen mention of format on the net but I don't know how to use it. My date variable is dteCurrDate and is assigned it's value by dteCurrDate = Me!StartDate. Can format be used here and if so, how?

 

[Jack Cowley]

Take a look at this article.

hth,
Jack

 

[-ian-]

To convert my British dates to U.S. for SQL, I use this:

Format(mydate, "mm/dd/yyyy")