Re: Date Operations in Stored Procedure

If these are actual date columns then simple date arithmetic will work:

if item > d1 and item < d2 then
...

etc.

You can test for overlap by using this in a SQL statement where clause (without the IF) against the start and end date columns.

--
-cheers
  DW
--------------------------------------------------------------------
"It is a kind of good deed to say well; and yet words are not deeds.
  -William Shakespeare"


Sent via Deja.com
http://www.deja.com/