Blog

I am trying to take the count of records in a list within a date period. my query render like this var qry = “<Where><And><Geq><FieldRef Name=’Requested_x0020_Date’ /><Value Type=’DateTime’>” + weekDates[“start”].toString() + “</Value></Geq><Leq><FieldRef Name=’Requested_x0020_Date’ /><Value Type=’DateTime’>” + weekDates[“end”].toString() + “</Value></Leq></And></Where>”; weekDates[“start”]=”dd/MM/yyyy” . my function is $ ().SPServices({ operation: “GetListItems”, async: false, listName: “Service Requests”, CAMLQuery: qry,Read more