date intervals

M

M

Anyone help?

I have two dates for each record, start date and end date. If the date
interval contains the date of April 2005 (nb the date range can be more than
one year) I need to identify these records. If the result is true for the
record then I need to calculate the number of working days between the start
and finish date.

e.g
start date end date result
01/01/2005 31/03/2005 false
01/01/2005 30/08/2005 true
01/01/2004 30/09/2005 true
 
J

Jeff Boyce

It sounds like you want to know if your record's StartDate is less than
April 1, 2005 AND your EndDate is later than April 30, 2005. You can do
that in a query, by setting those in the criteria row.
 
J

John Spencer

Anytime in April 2005?

Where StartDate <= #2005-04-30# and EndDate >= #2005-04-01#

The entire month of April

Where StartDate <= #2005-04-01# and EndDate >= #2005-04-30#
 
Top