Hello,
For a date field, I am trying to show the dashes (/).
Currently I am getting:
[ Latest Amendment #: 010 ] [ Amendment date: 03302011 ] [ Reason for Amendment: Change Contract ]

I am using the code below:


AMENDDT1/A8MDYY = IF CA_AMEND_REV_DATE NE ' ' THEN DATECVT(CA_AMEND_REV_DATE ,'MDY','A8MDYY') ELSE ' N/A ';

AMEND_DATA/A300 = ' [ Latest Amendment #: ' | CA_AMEND_REV1 ||' ] ' | ' [ Amendment date: ' |AMENDDT1 ||' ] ' | ' [ Reason for Amendment: ' | AMEND_REASON||' ] ';

any suggestions to show the dashes as follows:
[ Latest Amendment #: 010 ] [ Amendment date: 03/30/2011 ] [ Reason for Amendment: Change Contract Clause ]

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

paulux99,
One way of doing it would be to use the following logic: Instead of an A8MDYY field use an A10 field like:

COMPUTE AMENDDT1/A10 = IF CA_AMEND_REV_DATE NE ' ' THEN 
EDIT(CA_AMEND_REV_DATE,'99$$$$$$') ||'/'|| EDIT(CA_AMEND_REV_DATE, '$$99$$$$') ||'/'|| EDIT(CA_AMEND_REV_DATE, '$$$$9999')
ELSE ' N/A '; 
  

Using the EDIT will keep this as a 2 digit day, 2 digit month, and a 4 digit year.

Hope this helps

Well, if nothing else works you can do an edit

AMENDDT1/A10 = IF CA_AMEND_REV_DATE NE ' ' THEN EDIT(CA_AMEND_REV_DATE,'99/99/9999') ELSE '';

FYI


The reason for lack of slashes is because the format of the field is A8MDYY. With this format the date is stored as an 8 character string, and the slashes are added when the column is shown in a report.

Therefore to add the date to another string with the slashes in place, the slashes will have to be added.

thanks for all the suggestion. The following seems to work:
DEFINE FILE ...
AMENDDT/A8MDYY = IF CA_AMEND_REV_DATE NE ' ' THEN DATECVT(CA_AMEND_REV_DATE ,'MDY','MDYY')
ELSE ' N/A '
END
TABLE FILE ...
SUM
COMPUTE AMENDDT1/A10 = IF AMENDDT NE ' ' THEN EDIT(AMENDDT,'99/99/9999') ELSE '';
AMENDDT
ON TABLE HOLD
END
DEFINE FILE HOLD
AMEND_DATA/A300 = ' [ Latest Amendment #: ' | CA_AMEND_REV1 ||' ] ' | ' [ Amendment date: ' |AMENDDT1 ||' ] ' | ' [ Reason for Amendment: ' | AMEND_REASON||' ] ';
END

paulux99,
In your DEFINE If the AMENDDT is blank the format of A8MDYY will not like the value of 'N/A' from the ELSE statement. This may throw an error saying the value is incompatible with the format of the field.

A format of A10 will accept a value of 'N/A'.

ERINP