Testing for Overlapping Events with SQL - DayPilot Forums

Testing for Overlapping Events with SQL

Dave Abad — Thu, 07 Jun 2007 00:36:42 +0200

I know this is way sort of off topic but like the rest of you I'm developing a time / event scheduling app so I though I might save you some time and post this thing I've been banging my head against the wall working on. Namely since my app is being used to keep track off billable time I needed a way to make sure new events do not overlap any existing ones in my database.

Here's the SQL...

SELECT eventid from events WHERE(NOT((event_end < '" & newEventStartDate & "')
OR (event_start > '" & newEventEndDate & "')));"

Hope you find this helpful.

Dave

New reply to 'Testing for Overlapping Events with SQL'

Dan Letecky — Thu, 07 Jun 2007 09:57:00 +0200

Thanks for sharing the code, Dave!

New reply to 'Testing for Overlapping Events with SQL'

Tim Daldini — Thu, 12 Feb 2009 11:11:11 +0100

As far as I know, without the NOT that would be.

SELECT eventid from events WHERE((event_end >= '" & newEventStartDate & "')
AND (event_start <= '" & newEventEndDate & "'));"

This is exactly the same

New reply to 'Testing for Overlapping Events with SQL'

Dan Letecky — Tue, 17 Feb 2009 10:11:34 +0100

Thanks, Tim!