Date conversion

[hights]

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

 

[namliam]

1) You posted in the wrong place on the forum, this part is to introduce yourself. Not pose questions.
2) Welcome to the forum
3) As to your problem, you can solve this a couple of ways....
a function like:

Function db2DateConvert(db2Date As Double) As Date
    db2DateConvert = DateSerial(Left(db2Date + 19000000, 4), Mid(db2Date, 4, 2), Mid(db2Date, 6, 2))
End Function

would seem the best solution