Date conversion

[twes3]

Hello. I converted a JDE date that I get from our database to a CR date format (01/01/2006) using the formula below:

STRINGVAR JDEDATE;
numberVar JDECENTURY;
numberVar JDEYEAR;

JDEDATE := TOTEXT({Command.CDDFYJ}, "000000");
JDECENTURY := TONUMBER(JDEDATE[1]);
JDEYEAR := TONUMBER(JDEDATE[2 TO 3]) + 1900 + (100 * JDECENTURY);

(DATE (JDEYEAR,01,01) + (TONUMBER(JDEDATE[4 TO 6]) - 1));

My question is how to convert the date that I got (01/01/2006) to a (YYYYMMDD) format?

 

[synapsevampire]

Once it's a date, just right click it and select format field and select whatever format you want, or use custom for further choices.

-k

 

[Madawc]

Or ToText({Your.Date}, "yyyyMMdd"). The advantage of ToText is that it sticks whatever machine runs the report.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10