Create CAML query with have a value field with SharePoint column-SharePoint 2010

Question

I have a SharePoint list. It has two columns Start date and End date. I need to query and get data if (start date + 7 days> End date). Through CAML builder its not possible to have a SharePoint column on value node and build the query. Any idea? I have tried below. But not working.

<Query>
   <Where>
      <Eq>
         <FieldRef Name='EndDate' />
         <Value IncludeTimeValue='TRUE' Type='DateTime'><StartDate+7/></Value>
      </Eq>
   </Where>
</Query>

score 1 · Accepted Answer · edited Apr 13 '17 at 12:41

1

This question is similar to a question asked earlier here.

You can use Offset

Please check this link.

edited Apr 13 '17 at 12:41

Community

1

answered Jul 09 '14 at 10:25

Varun Verma

1,767
3
17
30

Please mark it as answer if it solves your query – Varun Verma Jul 09 '14 at 11:22
I need to have a column in the value field which is not in the FieldRef in CAML. – Sivakumar Piratheeban Jul 09 '14 at 12:50
are you using server object model or client object model? – Varun Verma Jul 09 '14 at 12:55
Server object model. – Sivakumar Piratheeban Jul 09 '14 at 13:42

Create CAML query with have a value field with SharePoint column-SharePoint 2010

1 Answers1