NULL date field in Crystal report.

Hi ,

I am getting a NULL value in date field.I have tried to handle that as
if Length(ToText({DTBRD3.termDate}))=0 or isnull ({DTBRD3.termDate}) then
” ”
else
ToText({DTBRD3.termDate})
.But its giving a blank field when report is exported in the excel.no grids are visible.
Can somebody help me.