0

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>
1

This question is similar to a question asked earlier here.

You can use Offset

Please check this link.

  • Please mark it as answer if it solves your query – Varun Verma Jul 9 '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 9 '14 at 12:50
  • are you using server object model or client object model? – Varun Verma Jul 9 '14 at 12:55
  • Server object model. – Sivakumar Piratheeban Jul 9 '14 at 13:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.