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>");

Answer 1

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.