on 10-04-2011 2:43 PM
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}
Thanks
Try
(If >={?From} or isnull( ) then ?? Need date field and operator here?? {?from} else >={?From})
Wrapped in () so that it can be used with other filters/clauses.
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.