T tegb Registered User. Local time Today, 18:05 Joined Feb 14, 2012 Messages 49 Jul 10, 2013 #1 How do I convert '130330' to date in Access? I want to convert to 03/30/13, any help will be highly appreciated
How do I convert '130330' to date in Access? I want to convert to 03/30/13, any help will be highly appreciated
pbaldy Wino Moderator Staff member Local time Today, 15:05 Joined Aug 30, 2003 Messages 36,270 Jul 10, 2013 #2 I'd use the DateSerial() function, along with the Mid() function to grab each part of the string.