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>