Convert text to Date

tegb

Registered User.
Local time
Today, 18:05
Joined
Feb 14, 2012
Messages
49
How do I convert '130330' to date in Access? I want to convert to 03/30/13, any help will be highly appreciated
 
I'd use the DateSerial() function, along with the Mid() function to grab each part of the string.
 

Users who are viewing this thread

Back
Top Bottom