I have hire dates and term dates that I ran in a report and it is over 10K
rows and I need to know if someone was hired in 2007 or before but terminated
in 2008. I also need to run the function for anyone who was hired in 2007 or
before and are still active.

Hi,

I think we need to see a sample of the data layout.
Do you want a count of these people or do you want to do a query on an
individual?

Mike

"Reenee" wrote:

I have hire dates and term dates that I ran in a report and it is over 10K
rows and I need to know if someone was hired in 2007 or before but terminated
in 2008. I also need to run the function for anyone who was hired in 2007 or
before and are still active.

Last Name First Name Hire/Term Date Active Fulltime Permanent
SMITH JOHN 05/23/2003 TRUE FALSE FALSE
SMITH JOHN 08/12/2003 FALSE FALSE FALSE
SMITH JOHN 04/22/2006 TRUE FALSE FALSE
SMITH JOHN 09/11/2006 FALSE FALSE FALSE
SMITH JOHN 08/10/2007 TRUE FALSE FALSE
SMITH JOHN 02/24/2008 FALSE FALSE FALSE

In this case John Smith was hired on 5/23/03 which represents true (active),
he was termed on 8/12/03 which represents he was not active any longer, then
he was rehired on 4/22/06 and termed again on 9/11/06 the last date of
8/10/07 was that he was rehired but was termed on 2/24/08 which is the
function I am trying to get. If there is anyway that I can filter out this
information without having to go through 10K rows and deleting out each row
it would be helpful.

I am hoping that excel can just display the people who were hired in 2007 or
before and terminated in 2008 without having to go through each row and
delete because I have so much information such as people who were hired in
2006 and termed in 2007 that I do not need and would like to just pick up the
ones that I really need to look at.

Thanks for your help!!


"Mike H" wrote:

Hi,

I think we need to see a sample of the data layout.
Do you want a count of these people or do you want to do a query on an
individual?

Mike

"Reenee" wrote:

I have hire dates and term dates that I ran in a report and it is over 10K
rows and I need to know if someone was hired in 2007 or before but terminated
in 2008. I also need to run the function for anyone who was hired in 2007 or
before and are still active.