3 Replies Latest reply on May 21, 2007 9:51 PM by Boogiebaby2

    Overlapping dates

    Boogiebaby2
      Hi, trying to work out how to check wether Form.startDate and Form.endDate fall in between other start or end dates in the database... currently using

      SELECT cmsPollsID
      FROM cmsPolls
      WHERE '#Trim(FORM.eventStartDate)#' BETWEEN cmsPolls.liveStartDate and cmsPolls.liveEndDate
      AND '#Trim(FORM.eventEndDate)#' BETWEEN cmsPolls.liveStartDate and cmsPolls.liveEndDate

      works when the start date is between dates but not the end date.

      Thanks