Good day all,
I have a serious problem using BO 5.1.3 It seems that the formula I’m using does not like one of my variables that I’m passing it.
I want to obtain a window of data from the query that lets me change the window on the target window on the fly.
For Example:
=<US Amt(Global)> Where (<Year(Global)>= “2004”)
Will bring the correct window of data.
Now if I want to make that formula dynamic and place the year in a variable it does not let me, see below:
=<US Amt(Global)> Where (<Year(Global)>= <Var_TargetYr>)
I have tried changing the format of the var_TargetYr as shown below
“2004”,2004,FormatNumber(2004,“0”)
and nothing works
Any suggestions
Thanks.
-Quick
quicka2 (BOB member since 2005-04-13)