Date Conversion

[hights]

Anyone any idea how I would convert YYMMDD TO DDMMYYYY in a query?
Here is an example of the date I am trying to convert....
130820 - I want to display 20/08/2013. Thanks.

 

[pr2-eugin]

Hello hights, Welcome to AWF..

Since the date you have is a String and not a normal date, you need the use of Mid function, maybe Left, Right and DateSerial to achieve what you want. Sample

? DateSerial(Left("130820", 2), Mid("130820", 3, 2), Right("130820", 2))
20/08/2013

 

[namliam]

Perhaps this will help you
http://www.access-programmers.co.uk/forums/showthread.php?t=253135

 

[hights]

your a genius !!! -Thanks for your help. Sorry for posting the thread in the wrong forum.