Hi

I have date filed formate (YYMD) comming form DB2 database

i want to show date formate in MDYY
Ex i/p data
2012/04/03
2011/12/06
2012/04/20
2011/08/22
2012/01/06


i want to display
04/03/2012
12/06/2011
04/20/2012
08/22/2011
01/06/2012


Can any one give me sol for this

Thanks
kumar.

This message has been edited. Last edited by: Kerry,

Is possible change format .
I give my example

TABLE FILE MOVIES
PRINT RELDATE/MDYY
END
I believe that you can get it whit this

Deepu,
there are couple way you can do this
Firstway you can create define file

DEFINE FILE CARS
date/MDYY = CAR.DATE
END
TABLE FILE CAR
PRINT
CAR.date 
END 

Another way (or simple way )

 TABLE FILE CAR
PRINT
DATE/MDYY
END  

This message has been edited. Last edited by: Jump_faster,