Hi, I'm looking for help.

I have a form that writes two dates to a database a Start Date and End date.

I want to be able to check the dates on the form dont alredy exist in the databse.

Ie if the databse holds the start date of 23/06/2006 and the end date of 29/06/06

I dont want the user on the form to be able to enter a date that is the same or falls between those date.

I know how to check a data against a date but not against a date range

What you can do is check if the user entered start date is between the two dates in the database and then do the same with the end date that the user entered. This will tell you if there's any overlap.

SELECT Count(*) FROM MyTable WHERE (@UserStartDate > StartDate AND @UserStartDate < EndDate) OR (@UserEndDate > StartDate AND @UserEndDate < EndDate)

will return the number of records where @UserStartDate or @UserEndDate falls between the StartDate and EndDate fields. (i.e. 0 if there's no overlap)

I'd just come up with my own method similar to yours but a lot more long winded. Thanks will try both methods out.