Need Help

[gireesh1216]

Hello Team,

I have a two fields. one is STATUS_DT and second one is EMPLID. Please find attached excel file.

Requirement: I have a STATUS_DT  filter and selecting two different dates(7/25/2003 and 10/30/2004) like below.But i am expecting all between dates( > =7/25/20003 to < =10/30/2004) employee count. 

OUTPUT: I am selecting only two dates  above but expecting all between dates employee counts like below:

Thanks,

Gireesh

[jonathandienst]

You need a set expression along the following lines:

Count({<STATUS_DT ={">=$(=Min(STATUS_DT))<=$(=Max(STATUS_DT))"}>} EMPLID)

The exact form depends on the data type and format of the date field. One option if the above does noit work is:

Count({<STATUS_DT ={">='$(=Date(Min(STATUS_DT)))'<='$(=Date(Max(STATUS_DT)))'"}>} EMPLID)

Add a DISTINCT if necessary:

Count({<STATUS_DT ={">=$(=Min(STATUS_DT))<=$(=Max(STATUS_DT))"}>} DISTINCT EMPLID)

[gireesh1216]

Thank you..