[AccessD] Strange date question

Susan,

So, in your example, if an Event begins on 1/9 and runs to 1/14, then
you want your query to DISinclude it, is that right? That is, the
starting and ending dates of the events must fall within the given
range.

I only had one other question: the "answer" you gave for your example
query was 6 days. Isn't it 8 days?

Steve Erbach
Neenah, WI


On Sat, 12 Mar 2005 20:22:48 -0500, Susan Klos <ksklos at comcast.net> wrote:
> I have a beginning date and an ending date in my events table.  I need to
> find out how many days in any given month that one or more events happened.
> For example,
> Event 1  Beginning Date 1/3/05   Ending date 1/3/05
> Event 2  Beginning Date 1/3/05   Ending date 1/4/05
> Event 3  Beginning Date 1/3/05   Ending date 1/8/05
> Event 4  Beginning Date 1/6/05   Ending date 1/7/05
> Event 5  Beginning Date 1/10/05 Ending Date 1/11/05
> 
> My query, function, module, whatever works needs to tell me:
> between 1/1/05 and 1/11/05 events happened on 6 days.
> I can not figure out how to disinclude events if they happened within the
> beginning and ending date of other events.
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>