Date Problem

K

kt2902

I have a table that contains the StartDate and EndDate for an employees leave
due to workplace injuries. What I need to do is filter the records for a
range of dates (eg. 1/1/2009 - 31/1/2009). I run into problems when the
employee doesn't fit exactly between these dates (eg. he was absent from
27/12/08 - 5/1/09). Even though five days is actually within the range
specified, my filter won't find the record. Is there a way around this or am
I asking too much of Access?

Thanks
Katie
 
A

Allen Browne

The logic to find overlapping dates is:
A starts before B ends, AND
B starts before A ends.

You can craft your criteria to match that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate within a time range with only start date and end date 2
Custom Date Partition Function 1
Arranging a data in required format 3
Counting Dates between a Start and End, Loop through records, providepeg counts 4
Count if between date parameters 4
Find Highest Date in a range 4
Formatting date gives bad results in query 2
Finding most recent date for each customer - XL 2007 2

Top