Overlapping dates

Results 1 to 2 of 2

Thread: Overlapping dates

  1. #1
    Steven L Guest

    Default Overlapping dates

    I've got a web page that takes a date range, and entries in the database have 2 dates, and I want to return the records where the date ranges overlap. How is the best way to do this?

  2. #2
    Steven L Guest

    Default RE: Overlapping dates

    Follow-up question:<BR>Can I use BETWEEN in the reverse of the standard, as to say <BR><BR>WHERE #somedate# BETWEEN events.startdate AND events.enddate<BR><BR>?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts