Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    year date format (2000 sr-1)

    i dont find the preciuos function maked by Hans...
    Have a var = 10/11/02 or 12/11/89, how to trsnform in 10/11/2002 and 12/11/1989....
    in effect year in YYYY from YY
    Tks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: year date format (2000 sr-1)

    Do you have 'real' date values, or text values that look like dates?

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: year date format (2000 sr-1)

    No real format date...
    I get this value from text file and have foamted as string....
    But if you have other way to transform directly the year in YYYY, are welcome.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: year date format (2000 sr-1)

    Say that you have a variable strDate. To convert it from dd/mm/yy format to dd/mm/yyyy format, you can use

    strDate = Format(strDate, "dd/mm/yyyy")

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: year date format (2000 sr-1)

    WORK SUPER FINE!
    Tks.

Posting Permissions

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