Oh wow... I didnt know about that... I'm using MSSQL 2000...
I'll try it out when I get back from my meeting. :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 12/2/2003 10:12:16 AM >>>
Candace Cottrell said:
>
> 1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Date Range Query Issues Candace Cottrell
- Re: Date Range Query Issues Jochem van Dieten
- Re:Date Range Query Issues Gabriel Robichaud
- Re: Date Range Query Issues Candace Cottrell
- Re: Date Range Query Issues Jochem van Dieten
- Re: Date Range Query Issues Mickael
- Re: Date Range Query Issues Jochem van Dieten
- RE: Date Range Query Issues DURETTE, STEVEN J (AIT)
- RE: Date Range Query Issues Candace Cottrell
- RE: Date Range Query Issues Tony Weeg
- Re: Date Range Query Issues Jochem van Dieten
- RE: Date Range Query Issues Tony Weeg
- Re: Date Range Query Issues Jochem van Dieten
- RE: Date Range Query Issues DURETTE, STEVEN J (AIT)
- Re: Date Range Query Issues Jochem van Dieten
- RE: Date Range Query Issues Candace Cottrell
- RE: Date Range Query Issues DURETTE, STEVEN J (AIT)
- Re: Date Range Query Issues Jochem van Dieten
- Re: Date Range Query Issues Jochem van Dieten