Date formula exporting to Excel as 1/0/1900

[jlr123]

My date formula for only viewing specific dates exports to Excel as 1/0/1900. What can I do to get a blank date in Excel? (blank dates viewed in Crystal exporting as 1/0/1900)

My formula:
if {AR_InvoiceHistoryDetail.UDF_CC_CODE}= "Rent" then {SO_SalesOrderHeader.OrderDate}

Thanks very much.

 

[pmax9999]

I just tested your formula and the only way I could get it to behave as your describe, is to export to XLS (Data Only) and have the setting Convert Null values to Default turned on, neither of which I ever use.

I find that if you spend a bit of time formatting the report the Data Only export option is not required, and I prefer to deal with NULLS explicitly so that I know I understand the data.

Hope this helps.

Regards,
Pete