Date fields can come in many different varieties. Visual Basic has a function called CDate that is able to figure out the majority of the formats and translate them into a common format. The following is the code for a custom function to do the change.
Function CtoDate(p1 As String) As Date
ctodate = CDate(p1)