CAML query for current date

Question

I want to get all items from the list, which has a start date from date.now or later in time.

This is what I thought would work:

var dateNow = Date.now();

 var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml(
    "<View>" +
    "<Query>" +
    "<Where>" +
    "<And>" +
    "<Eq><FieldRef Name='Title'/><Value Type='Text'>" + txtForNamn.value +</Value></Eq>" +
    "<Geq><FieldRef Name='vpux'/><Value Type='DateTime'>" + dateNow + "</Value></Geq>" +
    "</And>" +
    "</Where>" +
    "</Query>" +
    "</View>");

Paul Strupeikis · Accepted Answer · 2015-06-26T11:11:16.937

10

Replace

<Geq>
   <FieldRef Name='vpux'/>
   <Value Type='Text'>" + dateNow + "</Value>
</Geq>

with

<Geq>
    <FieldRef Name='vpux'/>
    <Value IncludeTimeValue='TRUE' Type='DateTime'><Now /></Value>
</Geq>

You can use <Today /> as well. IncludeTimeValue is, obviously, for including time in the query.

edited Jun 26 '15 at 11:11

answered Jun 26 '15 at 10:14

Paul Strupeikis

3,818
4
20
33

how does it look like when using ""? I don't think I want to include time. Thank you for helping me! – Dr Cox Jun 26 '15 at 10:17
Using "Today", without including time, would look like: – Paul Strupeikis Jun 26 '15 at 10:18
now it says "Error. Cannot complete this action.", I get the same when I'm trying to get from an earlier date :/ – Dr Cox Jun 26 '15 at 10:23
Try setting the IncludeTimeValue to 'TRUE'. Read the following resource as well: http://sharepoint.stackexchange.com/questions/32187/using-the-now-function-in-caml-query – Paul Strupeikis Jun 26 '15 at 10:42
3

Should there not be and ending </Value> tag above? – Robert Lindgren Jun 26 '15 at 10:53
1

Thanks! Missed that one. The query with "Today" should look like this: – Paul Strupeikis Jun 26 '15 at 11:11

CAML query for current date

1 Answers1