0 out of 1 rated this helpful - Rate this topic

DateRangesOverlap Element (Query)

SharePoint 2013

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>

Attributes

Attribute	Description
None	N/A

And, Or, Where

Minimum: 0

Maximum: Unbounded

Example

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

XML

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD