Built in functions within set analysis

[#1]

Hi,

I need an expression which counts the EMP_ID when the end date is between today and seven days from today

I tried to accomplish thus using the expression

=

count({$<End={'>=$(=date(today(),'MM/DD/YYYY'))'}>
+
$<Planned_End={'<=$(=date(today(),'MM/DD/YYYY')+7)'>}>}EMP_Id)

But,its not giving desirable results.Can anyone help me with the same

Note:I need this to be done  using set analysis and I do not want to make any changes in load scripting

[sparur]

Hi

what is your email? I will send my example