Checking Between 2 dates?

[bjblackmore]

Hi,
I have a database that users enter a start_date, and an end_date. However the user might try to add another record with dates between these 2 dates. Is it possible to check between date1 & date2 and return an error if its found?
I.e. user sets holiday 01072001 (1st July) until 14072001. If they then try to set another holiday for 07072001 to 14072001 it will error. At the moment it returns an error if they try to set the same dates twice, but it doesn't check in between.
Many Thanks
Ben

[cheald]

I'd store the dates as unix timestamps, then simply check if timestamp1 > x > timestamp2, return an error. Unix timestamps make it a good bit easier to work with dates.

[Anon]

If you find solution for this problem please send me an email.