Need to keep the no critieria cells blank when export to excel-currently fills with 01/00/1900

[sfsisa]

Hello, The results of this formula when exported to excel fill the cells that don't meet the criteria with 01/00/1900. How so I get the cells to be no criteria cells to be blank when exported?

if {PR1_EmployeeMaster.HireDate} in Date (2014,07,21) to Date (2014,08,20)and

{PR1_EmployeeMaster.BenefitScheduleCode} in ["01","75","80","83","85","87","90","95"]

then ({PR1_EmployeeMaster.HireDate})

Thank you
Lisa

I am using Crystal 10 with Sage 100 5.0

 

[Charliy]

if {PR1_EmployeeMaster.HireDate} in Date (2014,07,21) to Date (2014,08,20)and

{PR1_EmployeeMaster.BenefitScheduleCode} in ["01","75","80","83","85","87","90","95"]

then totext({PR1_EmployeeMaster.HireDate},"MM/dd/yyy")
else " "

You may need to change that date format to "dd/MM/yyyy" depending on where you are.

 

[SkipVought]

You cal always use a Conditional Format in Excel to make the display appear as BLANK or EMPTY.

 

[sfsisa]

Thanks Charliy, It fixed the problem. It is much appreciated.

Lisa