If your recipients don’t mind having to set the display formatting on the column to Date, the following code will create an Excel Date. (number of days since 12/31/1899)
d ExcelDate s 10i 0
c eval ExcelDate = %diff(%date(fld:*ymd):
c %date('1899-12-31'):*days) + 1
If the recipient doesn’t format the column to Date, they would see 39505 instead of 2/27/2008.
Note: The date will display in whatever format they choose (2/27/08, 27-Feb, etc)
Also, Excel Dates are only valid 1/1/1900 and greater
Kevin C. Ketzler