Blank Date field

Jet Reports Historic Posts

April 16, 2008 10:34

None

I am returning a "blank" date field from a Navision table.
The field looks blank but excel thinks there is something in it or its a text field.

Is there a way this field can be shown as a blank field.

Thanks
Garry

Date Votes

1 comment

0

Jet Reports Historic Posts April 21, 2008 20:26

I always use "=IF(NF(CellRef,"Date field")=0,"",NF(CellRef,"Date field")).

But maybe there's a better way to do this?

Comment actions Permalink

Please sign in to leave a comment.