We have a user who wants EXL2K output wherein the number of days will appear if certain date values appear but blanks, not zeroes, if the dates are not populated.

The original code returned the number of days as an alphanumeric and a dash (-) if the dates were not populated. Unfortunately, when handling the output in an Excel spreadsheet the sorting gets dicey if sorting on descending number of days if the alphanumeric appears.

How could we return a number of days if the dates appear but a blank if the dates are not populated? This looks to be a MISSING= (ON /OFF) application but I'm not certain how the attribute can be included in a define.

TIA - Sandy

ON TABLE SET EMPTYCELLS ON

Is supposed to produce Blanks instead of 0's
You may have set NODATA = something also.

MISSING works for me.(527)
DATE/format MISSING ON = IF whatever GT 0 THEN whatever ELSE MISSING;
..
and SET NODATA = ''
be sure there's no space between the 2 ' marks,
an empty cell and a cell with a blank in it are different to excel, but you know this.