Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DateRangesOverlap Element (Query)

Last modified: July 15, 2011

Applies to: SharePoint Foundation 2013 | SharePoint Server 2013

In this article
Attributes
Child Elements
Parent Elements
Occurrences

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


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

Attribute

Description

None

N/A

Minimum: 0

Maximum: Unbounded

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>
Show:
© 2015 Microsoft