isNull(DateField) not working 1

[petrovlis]

GoldminePE-SQLexpress/CRXI/VistaHP

In a formula I have a field where I put a date if Invoice is Paid.
I use :
isNull({Contact2.UO_PAID1}) C2.UO_Paid is Goldmine DateField
although it is not (yet)filled in/empty it gives
30 December 1899 00:00:00 as default,if I put/control it somewhere in the report to see what value is gives,

and therefor FALSE
In stead of True
So I need some else than :isNull(dateField)
Any idea ?
William

 

[IanWaterman]

In File options or Report options check to see if you have set null fields to default.

Uncheck and then Isnull should work.

Ian

 

[petrovlis]

Thanks Ian Waterman,
After some checking/unchecking I finally got is working!!

Thanks again!
William