formual problem for date printing in report

[dakotafox]

Because of the empty date value being interpreted at 12/30/1899 when creating a recordset from a VFP7 table, I have been working with this workaround but not successful. What am I missing in the statements?

The report field is printing as blanks for all dates, and does not put in the current record date value, when it is the second part of IIF.

formula=" "
IIF(year({crystal_wcp.discondate})=1800, " " ,cstr({crystal_wcp.discondate}))

Thank you for your help

 

[dakotafox]

Have just solved this formula, so thought that I would pass it on anyway.

formula=IIF({crystal_wcp.discondate}=#12/30/1899#, " " ,totext({crystal_wcp.discondate}))


This will work perfectly.