Converting date formats is giving me a headache.

On the HTML launch page the users want a date control that shows the date in the tDMYY format. I then need to convert this date ultimately to an I8YYMD format to use is as a condition in the procedure.

I am totally lost here ... Help!

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

I figured it out! The DT function works sweet!

 
-SET &MYDATE = EDIT(&DMYY,'$$$$9999')|EDIT(&DMYY,'$$99$$$$')|EDIT(&DMYY,'99$$$$$$') ;

DEFINE FILE CAR
MYDATE/I8YYMD WITH COUNTRY= &MYDATE;
END
TABLE FILE CAR
PRINT
MYDATE
WHERE RECORDLIMIT EQ 1 
END 

I'm sure others will come up with alternatives as well.