SytelineMaster

Use CDate to convert a string to a date/time. Dim d1 As Date Dim d2 As Date Dim d3 As Date d1 = CDate(“August 12, 2004”) d2 = CDate(“2:07:30 PM”) d3 = CDate(“August 12, 2004 2:07:30 PM”) Print d1 ‘ prints 8/12/2004 Print d2 ‘ prints 2:07:30 PM Print d3 ‘ prints 8/12/2004 2:07:30 PM