date checking

J

JaniN

I made a query to calculates employees monthly workdays, which uses two
separate dates to do it with dateserial function. Is it possible to make it
check actual starting date or ending date of employee, if it's past that
month's first or before month's last?
 
K

Ken Sheridan

You could perhaps use subqueries within the main query to find the MIN and
MAX dates per employee. I'm not sure just how you'd restrict the subqueries
so that they exclude any dates per employee from another before and after the
date range for which you are computing the workdays. If you can explain just
what determines the relevant date range I might be able to suggest something.

Ken Sheridan
Stafford, England
 
Top