Hello. I need to convert dates in this format to recognizable dates:

20121102 (formatted in text).

In Excel, the conversion formula is =DATE(LEFT(A1,4 ),MID(A1,5,2),R IGHT(A1,2))

I can not figure out how to convert them in Access.

Thanks!