Find active employees Between 2 dates how?

[NewToThis2]

CV9. I'm probably making this a lot harder than it has to be and once again I am turning to you experts out there.

My report must list active employees between 1-1-2004 and 6-1-2004. The only thing I can think to do is to exclude employees with a term date < 1-1-2004 or a term date > 6-1-2004. I'm just not sure how to do it.

Thanks in advance for your support!

 

[hilfy]

In your select expert, select the Term Date field, select "Is Not Between" and enter your dates.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

If you want a list of employees who were active at any time during the specified period, then use:

isnull({table.termdate}) or
{table.termdate} >= date(2004,01,01)

If you want a list of employees who were still active as of 6/30/04, then use:

isnull({table.termdate}) or
{table.termdate} > date(2004,06,01)

-LB