Locale and the Date variable

[jessie]

I use a chinese version of Windows XP. And excute a vb script code to get a
date value from a Excel file. The data value is in English format in the
Excel file. But I found the vb script converts it to chinese data format
automatically. So I can not compare it with another data variable as I
wish. So how can I force it to English date format? Thanks.

 

[Aaron Bertrand [MVP]]

Force a specific format.
http://www.aspfaq.com/2260
http://www.aspfaq.com/2313

 

[jessie]

Force a specific format.
http://www.aspfaq.com/2260
http://www.aspfaq.com/2313

I use oRS.Fields.Item(0).Value to read the data in Excel file, so it is a
string format variable when I read a date variable.
How can I read it directly as a date variable?
Thank you!