Sum by Date = null (blank)

[excalibur78]

I was wondering how I can do something like the following:
if {issue.date} = "" then 1 else 0 but it doesn't like it. How can I redo this to get it to work?

Thanks

David Dockham

 

[EscapeUK]

Try this

If Not IsNull({issue.date}) then 0 else 1

 

[excalibur78]

Thanks that works nicely.