CDate()
Brian Element
This function converst a valid date or time expression that is currently a string into a date type. The expression can contain only the date, only the time or both.
Script
Sub Main
Dim myDate As Date
Dim dateString As String
dateString = "Sept 19, 1964"
myDate = CDate(dateString)
MsgBox myDate
dateString = "07:45:00"
myDate = CDate(dateString)
MsgBox myDate
dateString = "09/19/1964 07:45:00"
myDate = CDate(dateString)
MsgBox myDate
End Sub