«

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.

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



"jessie" <> wrote in message
news:Xns942D8AF137D8Dallywzcnet@207.46.248.16...
> 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]" <> wrote in
news:#:

> 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!