Re: I am stuck and can't get a handle to solve this issue
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?