i have number in database 1 and want to convert as date in database 2
040792 19920506
040892 19920507
040992 19920510
187301 20010729
187401 20010801
187501 20010804
187601 20010805
result in database 2
407/92 06/05/1992
408/92 07/05/1992
408/92 10/05/1992
1873/01 29/07/2001
1874/01 01/08/2001
1875/01 04/08/2001
1876/01 05/08/2001
is it got any formula to convert this number from database 1 to database 2, so far i am doing manual.please help me thanks in advance
i has attach sample files..
Bookmarks