International Date Issue

[Guest]

Hello,

I have created an Access DB, to be used by people in the US & UK. The
Access DB enables a user to enter rerport parameters (date, region,
state....) into a form and run a report.

The problem I encounter is that when a UK user enters a date criteria
'12-01-2005' to '12-31-2005' the dates are reformatted into '01-12-2005' to
'31-12-2005'. How can I programmatically ensure all dates will follow the
mm/dd/yyyy convention.

Any help would be much appreciated.

Thanks
Acase

 

[Guest]

Hello,

I have created an Access DB, to be used by people in the US & UK. The
Access DB enables a user to enter rerport parameters (date, region,
state....) into a form and run a report.

The problem I encounter is that when a UK user enters a date criteria
'12-01-2005' to '12-31-2005' the dates are reformatted into '01-12-2005' to
'31-12-2005'. How can I programmatically ensure all dates will follow the
mm/dd/yyyy convention.

Any help would be much appreciated.

Thanks
Acase

Hi Check out: International Dates
in Access.

 

[Guest]

Hello,

I have created an Access DB, to be used by people in the US & UK. The
Access DB enables a user to enter rerport parameters (date, region,
state....) into a form and run a report.

The problem I encounter is that when a UK user enters a date criteria
'12-01-2005' to '12-31-2005' the dates are reformatted into '01-12-2005' to
'31-12-2005'. How can I programmatically ensure all dates will follow the
mm/dd/yyyy convention.

Any help would be much appreciated.

Thanks
Acase

Hi Check out: .

http://allenbrowne.com/ser-36.html[/url

 

[Guest]

Hello,

I have created an Access DB, to be used by people in the US & UK. The
Access DB enables a user to enter rerport parameters (date, region,
state....) into a form and run a report.

The problem I encounter is that when a UK user enters a date criteria
'12-01-2005' to '12-31-2005' the dates are reformatted into '01-12-2005' to
'31-12-2005'. How can I programmatically ensure all dates will follow the
mm/dd/yyyy convention.

Any help would be much appreciated.

Thanks
Acase

Hi Check out: web page International Dates In Access.

 

[Guest]

Larry,

The URL does not bring up a working page.

Hello,

I have created an Access DB, to be used by people in the US & UK. The
Access DB enables a user to enter rerport parameters (date, region,
state....) into a form and run a report.

The problem I encounter is that when a UK user enters a date criteria
'12-01-2005' to '12-31-2005' the dates are reformatted into '01-12-2005' to
'31-12-2005'. How can I programmatically ensure all dates will follow the
mm/dd/yyyy convention.

Any help would be much appreciated.

Thanks
Acase

Hi Check out: International Dates
in Access.