I think Marco has likely provided you the answer, you need to use dollar sign expansion with your variable. There's a brilliant article on how it works here: The Magic of Dollar Expansions
Thank you all for you responses. I have tried using the $ Expansion but still cannot filter the table. In my original post I stated I am trying to return only the rows that fall between the 2 variables. I had tried this expression behind the EffectiveDate ( which is a data field ) :
Hoping to return all rows between the variales vFromDate thru vToDate)
IF(Num(EffectiveDate) <= num(vToDate) AND ExpirationDate >= num(vFromDate) ,EffectiveDate))
IF(Num(EffectiveDate) <= num($vToDate) AND ExpirationDate >= num($vFromDate) ,EffectiveDate))
What can I possibly be doing wrong? Am I over thinking this? ugh?
You have 2 options:
1.- Use Set analysis, that way in your chart you will only get the dates that set analysis is evaluating.
2.- Create a field with the if statement IF(EffectiveDate<= vToDate AND ExpirationDate >= vFromDate ,EffectiveDate)
as you mentioned in your post.
Either the option 1 or the 2 will solve your issue.