Formula for null values 1

[micro2005]

CR 10 and SQL Server 2000.

I need to add a condition in the record selection for a null value. In other words I have to make sure that the records where the closuredate is null are selected. How can I do this?

Thanks in advance.

 

[lbass]

Try:

isnull({table.closuredate})

If that doesn't work, and assuming that it is a date field, try:

isnull({table.closuredate}) or
{table.closuredate} = date(0,0,0)

-LB

 

[micro2005]

Thank you! It works great.