c# - CAML 查询过滤日期范围内的数据

Question

我想从 SPList 中检索日期范围内的项目。开始日期为今天，结束日期为从今天起 30 天后的第二天。这是我的 CAML 查询。

query.Query = string.Concat(@
    "<Where>
        <And>
          <Geq>
            <FieldRef Name='EventDate' />
            <Value IncludeTimeValue='False' Type='DateTime'><Today /></Value>
          </Geq>
          <Leq>
            <FieldRef Name='EventDate' />
            <Value IncludeTimeValue='False' Type='DateTime'><Today offset='30'/></Value>
          </Leq>
       </And>
     </Where>
     <OrderBy>
       <FieldRef Name='EventDate' Ascending='True' />
     </OrderBy>");
SPListItemCollection items = list.GetItems(query);

但这只会返回具有今天日期的项目。

Answer 1

试试这个，使用 OffsetDays或 Offset不是offset在<Today/>值...

query.Query = string.Concat(@
    "<Where>
        <And>
          <Geq>
            <FieldRef Name='EventDate' />
            <Value IncludeTimeValue='False' Type='DateTime'><Today /></Value>
          </Geq>
          <Leq>
            <FieldRef Name='EventDate' />
            <Value IncludeTimeValue='False' Type='DateTime'><Today OffsetDays='30'/></Value>
          </Leq>
       </And>
     </Where>
     <OrderBy>
       <FieldRef Name='EventDate' Ascending='True' />
     </OrderBy>");

What is the difference between CAML Offset and OffsetDays?

或者，您可以创建 DateTime对象并使用 SPUtility.CreateISO8601DateTimeFromSystemDateTime method