How to check for Null

[crystal28]

If Not IsNull(ToText((currentdate-date({Command.ShipDate})),'00')) Then
ToText((currentdate-date({Command.ShipDate})),'00')
Else '00'

The above formula doesnt compile and says i need to give a field in If section

How do i write this without errors

I need to get the current date - date value of a field
and if its null then return '000'

 

[crystal28]

Also there is a formula in which i am concatanating the result of 3 other formulas,even when one of those is blank or null the formula that concatanates is blank..why is this and how to have data in it even if one of the other formulas are null or blank..

 

[dgillz]

If IsNull({Command.ShipDate}) then '00' else
ToText((currentdate-date({Command.ShipDate})),'00'))

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?