DateRangesOverlap Element

  • Article

The DateRangesOverlap element is used in queries to compare the dates in a recurring event with a specified DateTime value to see whether they overlap.

Syntax

<DateRangesOverlap>
</DateRangesOverlap>

Element Relationships

Parent Elements Child Elements
And, Where FieldRef, Value

Example

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

<Query>
   <Where>
      <DateRangesOverlap>
         <FieldRef Name="EventDate"></FieldRef>
         <FieldRef Name="EndDate"></FieldRef>
         <FieldRef Name="RecurrenceID"></FieldRef>
         <Value Type="DateTime">
            <Now/>
         </Value>
      </DateRangesOverlap>
   </Where>
</Query>