Date Calculation

[tmumaw]

Hi All, Need a little help with an expression.  I'm trying to count the number of active employees between a date range using set analysis.  I have 2 variables the user can select from on a screen.  First on is a valid from and the next one is a valid to.  From some reason just can't figure it out.  Thanks

Here is what I have so far:

Count({<Num_Date_ZWKDATE = {"=> $(vStartDate)"} & {"<= $(vEndDate)"}>}Distinct ActiveEmpID)

[bharathadde · Accepted solution]

Try this

=Count(Distinct {<Num_Date_ZWKDATE = {'>= $(=vStartDate)<= $(=vEndDate)'}>} ActiveEmpID)