string to date conversion

Results 1 to 3 of 3

Thread: string to date conversion

  1. #1
    anj Guest

    Default string to date conversion

    how do i convert a string to a date?<BR>example...TUE JUL 17, 2001 is not a DATE format, it&#039;s just a string! How can i convert it to a DATE format.<BR>pls help..thank you

  2. #2
    Join Date
    Dec 1969

    Default in VBScript? CDate()

    read the docs, please.

  3. #3
    Join Date
    Dec 1969

    Default RE: string to date conversion

    CDate is the way to go , however be careful because not all formats are supported, for example "TUE JUL 17, 2001" will return an error if you try to use CDate whereas "JUL 17, 2001" will not return an error and will convert successfully.Use the IsDate function to check whether or not you can succesfully convert a string to a valid date.<BR><BR><BR>MikeD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts