DateRangesOverlap 要素 (クエリ)DateRangesOverlap element (Query)

に適用されます: SharePoint 2016 |SharePoint Foundation 2013 |SharePoint オンライン |SharePoint Server 2013Applies 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.

属性Attributes

なしNone

子要素Child elements

親要素Parent elements

出現回数Occurrences

  • 最小 : 0Minimum: 0
  • 最大 : 制約なしMaximum: Unbounded

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>