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.
<DateRangesOverlap> <FieldRef Name = "Field_Name"/> <Value Type = "Field_Type"/> <XML /> </DateRangesOverlap>
Elements and attributes
The following sections describe attributes, child elements, and 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.
<Query> <Where> <DateRangesOverlap> <FieldRef Name="EventDate"></FieldRef> <FieldRef Name="EndDate"></FieldRef> <FieldRef Name="RecurrenceID"></FieldRef> <Value Type="DateTime"> <Now/> </Value> </DateRangesOverlap> </Where> </Query>