Skip to Content
Former Member
Oct 04, 2011 at 01:43 PM

Help with isnull funtion


HI, i am new to crystal and i have a little problem with isnull function, what i want to do is check to see if a value is null if it is then replace this with the value in the parameter for example in SQL i would do this

decalre @date datetime

set @date =getdate()+1

select date_col,col2,col3

from table where isnull(date_col,@date)=>getdate()

does anyone know how i do this in crystal here is what i have tried

( >={?From} or isnull( then {?from} else ) >={?From}