Set Analysis Help

[#1]

I am looking to find the number of employees that were terminated in the last 60 days.

SamAccountName is the employee itentifier

Term_Date is the date of termination

This is what I put together so far but I keep getting a result of 0....

=Count(DISTINCT{$<TERM_DATE={'>$(=today()-60)'}>}SamAccountName)

Any Ideas?

[swuehl · Accepted solution]

If your termination date format is e.g. 'MM/DD/YYYY', try

=count( DISTINCT {$<TERM_DATE = {">$(=Date(today()-60,'MM/DD/YYYY))"} >} SamAccountName)

[#3]

Thank you! That did the trick, I need to remember formatting!

Thanks Again

[#4]

=Count(DISTINCT{$<TERM_DATE={'>$(=Date(today()-60))'}>}SamAccountName)