Locale and the Date variable

Discussion in 'ASP General' started by jessie, Nov 8, 2003.

  1. jessie

    jessie Guest

    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.
     
    jessie, Nov 8, 2003
    #1
    1. Advertising

  2. 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], Nov 9, 2003
    #2
    1. Advertising

  3. jessie

    jessie Guest

    "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!
     
    jessie, Nov 9, 2003
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Maurice Hulsman
    Replies:
    1
    Views:
    1,915
    Guus Bosman
    Jul 25, 2004
  2. Replies:
    4
    Views:
    1,047
  3. Gabriel Genellina
    Replies:
    0
    Views:
    737
    Gabriel Genellina
    Feb 18, 2009
  4. zade
    Replies:
    1
    Views:
    641
    James Kanze
    Mar 5, 2010
  5. Sibylle Koczian
    Replies:
    2
    Views:
    1,155
    Sibylle Koczian
    Nov 20, 2010
Loading...

Share This Page