Hello all. What is the best way to create a YYM date from a table with:
1) year that is stored as A4, e.g. "2005"
2) month that is stored as I2, e.g. 9

(I'm not using SQL passthrough - just regular webFOCUS functions). Thanks in advance.

DEFINE FILE CAR
TYEAR/A4 = '2005';
TMONTH/I2 = 9;
TDATEX/A6YYM = TYEAR | EDIT(TMONTH);
TDATE/YYM = TDATEX;
END
TABLE FILE CAR
PRINT TDATE
BY COUNTRY
END

Off the cuff, I would try:

ALPHADATE/A6YYM=YEARA4 | EDIT(MTHI2);
SMARTDATE/YYM=ALPHADATE;

That works! Thanks a lot.