Is there a function on WF that will take a Smart Date formated field that is a format of "Mtr" and put the fullword of the month into an A9 alpha field?

Don't ask me why I wnat to do this because it would take too long to explain what I am doing. I am neck deep into a complicated but really cool report program.

This message has been edited. Last edited by: <Kathryn Henning>,

Wishful thinking!

I've found that we have to use DEFINE or COMPUTE. Here, I've typed it out for you, so you don't have to

MTR/A9 = DECODE MX (
01 January  , 02 February, 03 March   , 04 April
05 May      , 06 June    , 07 July    , 08 August
09 September, 10 October , 11 November, 12 December ELSE '');

Thanks Francis for the thoughtfulness. However, I already coded the whole thing before I posted my question. I was just wondering if there was a simplier way. Apparently we need 1002 ways to work with dates in WF.

Spoke too soon!

TABLE FILE GGORDER
SUM
ORDER_DATE NOPRINT
COMPUTE ORDER_DATEA/A8YYMD = ORDER_DATE;
COMPUTE ORDER_MTR/A17 = CHGDAT('YYMD','MX',ORDER_DATEA,'A17') ;
BY ORDER_DATE NOPRINT
WHERE READLIMIT EQ 10
END

Or

TABLE FILE GGORDER
SUM
ORDER_DATE NOPRINT
COMPUTE ORDER_DATEA/A8YYMD = ORDER_DATE;
COMPUTE ORDER_MTR/A9 = LCWORD(9, CHGDAT('YYMD','MX',ORDER_DATEA,'A9'), 'A9');
BY ORDER_DATE NOPRINT
WHERE READLIMIT EQ 10
END

Very Good