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>
Improve this question

1 Answer 1

Reset to default
1

This question is similar to a question asked earlier here.

You can use Offset

Please check this link.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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