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.

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

1 Answer 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 Jul 9, 2014 at 11:22
  • I need to have a column in the value field which is not in the FieldRef in CAML. Jul 9, 2014 at 12:50
  • are you using server object model or client object model? Jul 9, 2014 at 12:55
  • Server object model. Jul 9, 2014 at 13:42

Your Answer

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

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