Results 1 to 2 of 2

Thread: text to date

  1. #1
    Join Date
    Aug 2009
    Posts
    73

    Question Unanswered: text to date

    ABC
    ------
    12.2005
    13.2001
    12.2009



    i have following column of type text but it has value of dd.yyyy

    want to convert it to date type , how can we do it , pls help me with query

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    UPDATE mytable SET mydatecolumn = CDATE(left$(mytextcolumn,2) & "/01/" & right$(mytextcolumn,4)
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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