What is the blank value for date field ?

[c8ltgkue]

Hello All

Using CR XI

I have a date field which is empty. I am trying to create a formula which shows where there is no value in the date field. I am using the Isnull() function but it doesn't work. Does any one know what to put in the formula to identify blank date ? i.e for string fields one could use
table.field = "". I am trying to find the equivalent for date field.

Many thanks

C8

 

[lbass]

Try date(0,0,0).

-LB