Datetime - problem with Time part

• Danie Coetzee

  SSC Journeyman

  Points: 86

  More actions

  January 12, 2007 at 5:22 am

  #176436

  I am trying to use an Activex script in DTS to combine two strings into the a datetime field.

  eg: "2006/01/01" and "10:50:30"

  I can do the date part, using dateserial, but how do I get the time in ?

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  January 12, 2007 at 6:18 am

  #682881

  dim dt

  dim sdt

  dim stm

  sdt = "2006/01/01"

  stm = "10:50:30"

  dt = dateserial(cint(left(sdt, 4)) cint(mid(sdt, 6, 2)), cint(right(sdt,2))) + cdate (stm)

  Russel Loski, MCSE Business Intelligence, Data Platform

• Danie Coetzee

  SSC Journeyman

  Points: 86

  More actions

  January 14, 2007 at 11:27 pm

  #683153

  Thanks Russel - you are a star !