Date Interval Functions

[Lynn]

On a form I have

Date_Start Date_End

I have a new
Date_Start1 Date_End1 which the use
inputs.

I need to validate that Date_Start1 and Date_End1 are a date range
entirely separate from Date_Start and Date_End i.e. no overlapping
whatsoever. In effect checking a date interval.

Are there any functions out there already written that can do this? It
seems to basic to start comparing and contracting dates! Would like to
do it in Javascript, but happy in vbscript also.

Thanks,
Lynn

[Bob Barrows]

Lynn wrote:

> On a form I have
>
> Date_Start Date_End

Already answered over at .asp.general. Please do not multipost. This
question, as asked, has nothing to do with databases, so there was no point
to posting it here. Posting it here as well as in .general did not increase
your chances of getting an answer (most of us subscribe to both groups). On
the contrary, if somebody had taken his time to answer it here, only to find
that it was already resolved in the other group, that person may have been
annoyed enough to ignore any future posts from you, thereby decreasing your
chances of getting help in the future.

There are times when you will not be sure which group is most appropriate
(again, this was not one of them), and you will want to post a question to
both groups. In that situation, you should use the cross-posting technique,
rather than posting the same message multiple times. To crosspost, put a
semicolon-delimited* list of the newsgroups to which you wish to post in the
To: header of your post and post it once. It, and any replies to it, will
appear in all the newsgroups in your list. So, if I reply in .asp.general,
my reply will also appear here in .asp.db.

* ... or whatever delimiter is recognized by your news client

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"