not going to work in sql server 2000, not from what I can see in the
docs....

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-----Original Message-----
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 10:22 AM
To: CF-Talk
Subject: Re: Date Range Query Issues

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]

Reply via email to