Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Location
    Brooklyn, ny
    Posts
    69

    Unanswered: convert text to the date/time

    hello ,

    I have a table with a field (datatype as a text) which has a date in it as a text (12022005, 12222005, 01022005, 02252005 etc)

    I need to have a insert into query that will convert that field to the date/time as 12/02/2005, 01/02/2005 etc
    while the table is populated with
    insert into tlbname
    select ...
    from

    New table has to have a date/time datatype.


    Thank you

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    same as i told you last week
    you will also need to fix that ugly text date
    see help on left$(), mid$(), right$()
    ...and maybe also dateserial() - but that's a matter of taste
    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    ... and then use the CDate function ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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