xls format of a report

[unknownly]

I have a formula fields
where

@saledate

if date_type = 'SALE'
then
startdate

@Rentdate
if date_type = 'RENT'
then
startdate

Dislays as

Sale dt Rentdt
01-20-2005
04-20-2005
05-20-2005
02-10-2005
10-10-2005
11-01-2005

It looks fine in pdf format but I users export this output as XLS file the fields which are null show up as ########

How can I change my formula so when the report is exported to XLS file should show as blank. I keep getting the date is required error when iam using else part in my formula.

Thank you all for the help.

Sweetie

 

[synapsevampire]

Try:

if date_type = 'SALE'
then
totext(startdate)
else
"N/A"


@Rentdate
if date_type = 'RENT'
then
totext(startdate)
else
"N/A"

Or you could default to a different date if you wish to make sure that the exported data type is a date, such as:

else
cdate(0,0,0)

-k