Hello there,
I'm trying to write a report that needs to retrieve the number of calls received into the center every month, but I stuck in how to return the name of the month not the number of the month. I'm using here the REDEFIN the name of the field as the following code:

DEFINE FILE CALL_CENTER/CALL_STATS
C_MONTH REDEFINES CALL_STATS.CALL_STATS.C_MONTH = LCWORD(10, CHGDAT('YYMD','MX',C_MONTH,'A10') ,'A10');


END
TABLE FILE CALL_CENTER/CALL_STATS
.
.
.
anyone knows how to display the name of the month instead of the number please?

This message has been edited. Last edited by: Badr.A,

Try switching the format from YYMD to YYMtrDm.

There are several ways and format available (short, long, w/ or w/o year, ...). Depending on the format of the source Date, you may have to use more than one function.

Below are some sample (also Babak one)

DEFINE FILE GGSALES
Mth/Mtr = DATE;
YMthD/YYMtrD = DATE;
YMth/YYMtrDm = DATE;
END
TABLE FILE GGSALES
PRINT DATE/Mtr
      Mth
      YMthD
      YMth
BY DATE
WHERE READLIMIT   EQ 5;
WHERE RECORDLIMIT EQ 5;
END

thank you, it works as I want by Define method, I was using REDEFINE.

Badr,

Edit your first post then in the subject, at the beginning add [SOLVED].

Tks