comparison using set analysis

[#1]

Hi,

I want to compare the end date with the current date within a set expression,if the end date is lesser than the current date,i would want to perform a count on empid i.e., I need a function to perform something like this count({$<End={'<today()'}>}Emp_ID) .So can anyone explain how this could be acheived?

[tresesco]

try like:

Count({<End={'<$(=Date(Today()))'}>} Emp_ID)

[#3]

count({<End = {"<$(=today())"}>} Emp_ID)

[MayilVahanan]

Hi

Try like this

Count({<End={'<$(=Date(Today()))'}>} Emp_ID)

And make sure , the date format are similar. If vary,

Try with

Count({<End={'<$(=Date(Today(),'MM/DD/YYYY'))'}>} Emp_ID)

Instead of 'MM/DD/YYYY' -> use ur format

[#5]

Hi Mayil,

Thanks for the solution

[#6]

Hi

Can you you please explain how the same functionality could be achieved by equating the end date’week to today’s week within the same set expression