Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

International Date Problems

Status
Not open for further replies.

culshaja

Programmer
Aug 10, 1999
705
GB
Hi,
I have an application that is used in different countries.
When people enter dates in France the dates are not accepted if they enter a 3 letter month code i.e. mai = may.
When I change the local settings on my machine to French and issue dteDate = CDate("20 Mai 2000") through the Visual Basic immediate window the date is accepted. However, when I use IE5 and input the date into the field the client-side VBScript validation using CDate does not recognise the date as being valid.

I did read that VBScript always interprets a date literal as US-English if it is possible to do so (VBScript Glossary on MSDN). However, I believe that I am passing a date expression.

Any ideas?

James [sig]<p>James Culshaw<br><a href=mailto:jamesculshaw@active-data-solutions.co.uk>jamesculshaw@active-data-solutions.co.uk</a><br><a href= Active Data Solutions</a><br> [/sig]
 
I dunno if it will work or not, but have you tried changing the locale identifier?
Code:
Session.lcid = 1036
does it for France

HTH,

Kevin [sig][/sig]
 
Will that propogate back to the client from the server. The client machine international settings is set to france. What would the impact be for clients in the UK?

James :) [sig]<p>James Culshaw<br><a href=mailto:jamesculshaw@active-data-solutions.co.uk>jamesculshaw@active-data-solutions.co.uk</a><br><a href= Active Data Solutions</a><br> [/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top