String to Date Conversion

[AbeMeister]

I need to convert a bunch of Text Strings to Date. Any help would be appreciated.

SCENARIO:
I have 1260 records with Dates with the Format of YYYYMMDD, They are in Text Fields. How can I go about converting them to a date format so I can evaluate them in other apps?

 

[RobertT687]

Create a function like:
Public Function MakeDate(InDate As Variant) As Date
MakeDate = CVDate(Left$(InDate, 4) & "/" & Mid$(InDate, 5, 2) & "/" & Mid$(InDate, 7, 2))
End Function

 

[AbeMeister]

Thank you very much!

 

[nathanstevenson]

Hi, this might be a bit of a stupid question,
but how would you call this function for a selection?

I have the same problem and have tried a different approach to no avail.

-Nathan