Hello
I have a date in the A10 format (separationDate)

I need to have a define field of separationMonth that would be MYY format.

I also need to have a define field of separtionYear that would be YY format.

I've tried DPart and CHGDAT and can't get it to work.

thanks for the help.

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

 
DEFINE FILE datetest
NEW_DT/A8MDYY=EDIT( MYDATE ,'99$99$9999');
DATE_M/MYY=NEW_DT ;
DATE_Y/YY=NEW_DT ;
END

TABLE FILE datetest
BY MYDATE
BY DIM
BY NEW_DT
BY DATE_M
BY DATE_Y

END
 

thank you very much
that worked.