Date Variable Set Analysis

[wonkymeister]

Help please,

I need to subtract one date from another (which is fine)

But the date that i am subtracting from is in a variable (vPeriodEnd), and my expression isn't working (it works fine with a standard field, its the variable that is causing me the headache). The date held within the variable is ok, as is the format.

any ideas?

if(

     only({<

          month=

          ,year=

          ,absence = {'Sickness'}

          ,census_date={'>=$(=$(vPeriodStart))   <=$(=$(vPeriodEnd))'}

     >}$(vPeriodEnd))

-

     only({<

          month=

          ,year=

          ,absence = {'Sickness'}

          ,census_date={'>=$(=$(vPeriodStart))   <=$(=$(vPeriodEnd))'}

     >}start_date)

> 28, 'Yes', 'No')

[wonkymeister]

yes - all matched,

[wonkymeister]

sorry guys - this was a total mistake on my part - the set was fine, the issue was with logic outside of the expression.

sorry guys and thanks to every one who contributed!