DateRangesOverlap element (Query)

Applies to: SharePoint 2016 | SharePoint Foundation 2013 | SharePoint Online | SharePoint Server 2013

Used in queries to compare the dates in a recurring event with a specified DateTime value to determine whether they overlap.

  <FieldRef Name = "Field_Name"/>
  <Value Type = "Field_Type"/>
  <XML />

Elements and attributes

The following sections describe attributes, child elements, and parent elements.



Child elements

Parent elements


  • Minimum: 0
  • Maximum: Unbounded


The following example compares the event date and end date of a recurring event with the current date and time.

         <FieldRef Name="EventDate"></FieldRef>
         <FieldRef Name="EndDate"></FieldRef>
         <FieldRef Name="RecurrenceID"></FieldRef>
         <Value Type="DateTime">