date intervals

G

Guest

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#
 

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

Converted from LINUX time ok, but having issues with the between date. 4
Create List of Dates that fall between 2 Dates 2
Oldest date 2
Sum values in a "chronlogical date list" from "transactions table" 5
next date?? 1
Creating a "grid" of data 3
Return multiple records from a single entry. 2
Access not recognizing Date Format 3

Top