Variables

[i257156]

Hi Guys,
I am trying to write a variable which is an if statement with in Business Objects but it isn't playing ball.

This is what I think I wanna type:

=If<Outcome Date> = &quot;&quot; Then(DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)> , CurrentDate())Else(DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)> ,<Outcome date>))) End If

Can anyone see where I am going wrong here??
Cheers
JB

 

[BrianTyler]

I am not an expert but try this:


=If IsNull (<Outcome Date>) Then (DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)>,CurrentDate()) ) Else DaysBetween (<Initial Contact Date(Query 4 with BOCI001U)> ,<Outcome date>))

 

[i257156]

You had an extra bracket on the end!
But other than that it works perfectly..
Thanks a million
JB