Date formats?

[acepayne]

Hi there,

I have a date/time field in a table where I have set the format to "mm/dd/yyyy". Oh, I should mention that my Regional setting is "US English".

Now, I have a form to add a record to this table, with this date field defaulting to today's date (Date()). I have set the format for this text box to "mm/dd/yyyy".

When the form loads, the date displays as desired, but as soon as I click in the text field, it tends to reverse the mm and dd parts.

Example: today it will display 12/04/2001, but as soon as I click in the text box, it changes to 04/12/2001.

Is there something I can do to rectify this, or should I just bite the bullet and have everything displayed as "dd/mm/yyyy"?

Any help is appreciated!

Thanks,
Ace

 

[Rich]

What is the Country region set to?

 

[acepayne]

Hi,

The country was set to Canada, and changing that fixed my latest dilemna. I was fooled by Windows' alternate language feature. I was under the impression that simply changing that to US English would do the job. Wrong!

Thanks again Rich!

Cheers,
Gord