Getting less than (Today+7) days items using caml query

Question

I want to retrieve items from list which are lessthan seven days from today date.

Today date:12/14/2015

seven days means: 12/21/2015.

Using caml query. can anybody know please tell me.

score 20 · Answer 1 · answered Dec 14 '15 at 09:03

20

In a caml query, you will need to use <Today> token with OffsetDays.

For e.g.

<Where><Leq><FieldRef Name='Your_Date_Column' /><Value Type='DateTime'><Today OffsetDays='7' /></Value></Leq></Where>

Reference: Using the Today token in a CAML query

answered Dec 14 '15 at 09:03

P S

4,827
4
27
50

score 5 · Answer 2 · edited Jun 15 '20 at 08:48

5

Let SharePoint do the work for you

You can Filter by date in the View Filter settings,
This shows the Items created in the Last Week:

Important:

You can use spaces (and linebreaks) in a Calculated Column Formula,
but do NOT use spaces in this Filter Formula

If you do, you get the most informative message:

edited Jun 15 '20 at 08:48

Community

1

answered Dec 14 '15 at 08:56

Danny '365CSI' Engelman

21,176
7
35
79

But if any items gets updated later week again this calculated date will get updated. – Gaurravs Dec 14 '15 at 08:57
This is not a Calculated Column/Field. It is a View Filter calculation, executed every time you open the View. You can put references to Calculated Columns here, but you can not use Today in a Calculated Column – Danny '365CSI' Engelman Dec 14 '15 at 09:21
FYI. Today can be used in calculated columns. I have used it several time.. just you cannot use it simply like above – Gaurravs Dec 14 '15 at 10:00

score 2 · Answer 3 · answered Dec 14 '15 at 08:55

2

Use following code if using jquery:

var lastWeek = new Date();

lastWeek.setDate(lastWeek.getDate() + 7);

now you can use this variable the way you want. I hope this is what you were in need

answered Dec 14 '15 at 08:55

Gaurravs

3,558
12
22
33

score 1 · Answer 4 · answered Apr 18 '16 at 06:08

objQuery.Query = "<Query><Where><And><Geq><FieldRef Name='EventDate' /><Value IncludeTimeValue='TRUE' Type='DateTime'><Today OffsetDays='7' /></Value></Geq><IsNotNull><FieldRef Name='Title' /></IsNotNull></And></Where><OrderBy><FieldRef Name='EventDate' Ascending='True' /> </OrderBy></Query>";

score 0 · Answer 5 · answered Apr 13 '20 at 14:42

The Query where we can view the current week seems to be as below:

<Query>
  <Where>
     <DateRangesOverlap>
       <FieldRef Name='EventDate'/><FieldRef Name='EndDate'/>
       <Value Type='DateTime'>
           <Week/> 
       </Value>
     </DateRangesOverlap>
  </Where>
</Query

Getting less than (Today+7) days items using caml query

5 Answers5

Important: