I am trying to convert a date to the form: three letter monthh followed by year. An example is Jan11. Itried the following format: LABLMON/MtY = REPMON;. The result comes out: Nov, 97
Is there a way to remove the comma?
I only want to see the three letter month followed by the two digit year.

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

This might work. Add function LCWORD if you need the month in proper case.

LABLMON/A6 = EDIT(CHGDAT('MDYY','MTY',REPMON,'A17'),'999$99');