Hey users,
We are running a large project where we have to create extracts in a csv format output. I am using the COMT format for this, but it removes all the forward slash (/) date separators when the file is saved to the upload location. Does anyone know of a way to keep the original formatting to keep the date in 08/03/2018 form instead of it overwriting the date to reflect as 8032018?

I have a few dates hard coded into the report, and those come across with the forward slash separator and they are not removed. It is only removing the separator for MDYY fields pulled into the report.

Thank you for any help!
-Larissa

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

Larissa, try this.

TRX_DATE1/A8MDYY = TRX_DATE ;
TRX_DATE2/A10 = EDIT(TRX_DATE1, '99/99/9999') ;

It produced this...
08012018,"08/01/2018"
07272018,"07/27/2018"
07252018,"07/25/2018"

Les - You did it! This worked perfectly. Thank you my friend!
-LB

First, COMT was not removing the "/". The "/" were removed because COMT is a file format. The exact same thing happens with HOLDFORMAT ALPHA, SAVE, TABT, etc. file formats. When creating a HOLD file, if you want to save the formatted output of a field, try using FPRINT. Assuming TRX_DATE is a smart date:

PTRXDT/A10=FPRINT(TRX_DATE,'MDYY','A10');

TRX_DATE could have a default format of YYMD, but PTRXDT will be "MM/DD/YYYY" in the COMT file.