Does anyone know how to write translated dates to a hold file? For example if field THEDATE/YYMD contains 2012/10/31 I would like to write 31 October, 2012 to a HOLD file using format DMtrYY (instead of the internal number)

Thanks, Ruhan

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

Look at the CHGDAT and the DATETRAN functions:

TABLE FILE CAR
SUM 
SALES
COMPUTE THEDATE/YYMD = '2012/10/31';
COMPUTE THEDATEA/A8YYMD = THEDATE; 
COMPUTE THEDATEX/A17 = CHGDAT ('YYMD', 'DMXYY', THEDATEA, 'A17');

COMPUTE THEDATEB/A30 = DATETRAN (THEDATE, '(DMYY)', '(wrctrdo)', 'EN', 30, 'A30');

COMPUTE THEDATEC/A30 = DATETRAN (THEDATE, '(DMYY)', '(trcdo)', 'EN', 30, 'A30');


BY COUNTRY
END

CHGDAT will not give you mixed case and DATETRAN is confusing but any date format can be squeezed out.

This message has been edited. Last edited by: Francis Mariani,

The one piece of info missing is the background.

To hold a formatted date, it must be converted to an alpha string.

Why do you need the date held this way ?

Thanks, Francis. I was just wondering whether one could get by without using a subroutine.

Ruhan