Converting a text field into a Date Field

[SherriKilgore]

I have a text, date field I need to convert to a date field.

For example: 2/11/14 is stored at text: 21114.

How can I convert the 21114 into 2/11/14?

 

[plog]

Uh oh. Is January 11, 2014 stored the same as November 1, 2014?

 

[SherriKilgore]

No November would be 110114 and January would be 10114.

 

[Frothingslosh]

Basically, what you'll need to do is use string manipulation to insert the slashes in the right space, and then it can be converted to a date with CDate.

CDate(Left(DateString, Len(DateString) - 4) & "/" & Mid(DateString, Len(DateString) - 3, 2) & "/" & Right(DateString, 2))

DateString is a string variable containing the string you're converting. You'll need to change that name to fit your code.

 

[SherriKilgore]

Thank you so much, this works perfectly.

 

[SherriKilgore]

Thank you, this works perfectly