Question (text date converted to proper date into access table)

[learning...@gmail.com]

Hi,

I am trying to convert the text date (wrong date) into date format in access. I realized that I noticed the date was not corrected.


In text file in access table showed:
00061002

I used the query to format the date:
IIf([RegistrationDate] Is Not Null,Format(CDate(Format([RegistrationDate],"00\/00\/00")),"mm/dd/yyyy"))

I got the result showed:
06/02/2002

It should be 10/02/0006.

I need to know how to convert to 10/02/0006 instead of 06/02/2002.

Your help will be appreciated.

Thanks