Hi,
Need some tips on converting date in QYY to Alpha format.

Thanks.

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

I imagine that the QYY date is really in integer or alpha format. Or it is a real date field that has been reformatted to QYY.

It is very easy to do but we require a bit more information.

Here's one example:

-*
DEFINE FILE CAR
CNTR/I5 WITH CAR = CNTR + 1;
DTE/A8YYMD = DECODE CNTR (1 '20100115' 2 '20100415' 3 '20100715' 4 '20101115');
SD_QYY/QYY = DTE;
T1_QYY/A7 = 'Q' | EDIT(DATECVT(SD_QYY, 'QYY', 'Q'), '9 ') | EDIT(DATECVT(SD_QYY, 'QYY', 'YY'));
END
-*
TABLE FILE CAR
PRINT
CNTR
DTE
SD_QYY
T1_QYY
WHERE RECORDLIMIT EQ 4
END

Jim

Yes , it is a real date field.
It looks like Q2 2010

What does the meta-data look like? The Master file information about the field? The values may look like Q2 2010, but the "real" date field is not defined as QYY.

Jim has provided one way to convert the field.

Got it with jfr99's suggestion. Thanks a lot!