[Stackoverflow] [Progress OpenEdge ABL] How to change date format while exporting as a csv file?

[Thiru]

I use below code and its working fine. I don't want to change temp table field(dActiveDate) type but please help me to change the date format.

DEFINE TEMP-TABLE tt_data NO-UNDO
   FIELD cName AS CHARACTER
   FIELD dActiveDate  AS DATE.

   CREATE tt_data.
   ASSIGN
     tt_data.cName = "David"
     dActiveDate     = TODAY
     .
   OUTPUT TO value("C:\Users\ast\Documents\QRF\data.csv").
   PUT  UNFORMATTED "Name,Activedate" SKIP.
   FOR EACH tt_data NO-LOCK:
     EXPORT DELIMITER ","  tt_data. /* There are more than 15 fields available so using export delimeter helps to have less lines of code*/ 
   END.
   OUTPUT CLOSE.

Continue reading...