URGENT: Date formatting function on PC with regional setting set to French (Canada)
Posted on 2005-05-03
First off, sorry about the point value, but it's all I have.
I have a database system with forms, installed on various user PC's. Most PC's regional settings are set to US (English) but I have a couple that are set to French (Canada).
The problem is in a part where I have a user enter a date in text form into a textbox in the format "mm-dd-yy".
When I type in "01-01-05" and format it as a date on the US ENglish boxes, the date is formatted fine, but on the french PC's, it becomes "01/05/2001".
Obviously, not good. I've been trying variations of date formatting functions on it, but to no avail.
Anyone know of a way to force the locale to US through code, or any other solution.
I'll increase the points to 200 if someone doesn't mind this being open for a while as I redeem more points.