I'm trying to perform a CAML Query test and display the results.
For example I'll be using two columns in a list; one called StartDate another called EndDate.
Currently, I've a CAML Query that orders the StartDate column and displays the first five items in the list.
CAMLQuery: "<Query><OrderBy><FieldRef Name='StartDate' Ascending='True'/></OrderBy></Query>",
CAMLRowLimit: 5,
What I need to do is to write something that will look at the EndDate column and make a comparison to today's date. If that date has already passed it shouldn't turn up in the results.
Therefore, the 5 list items appearing will not have an EndDate that has already passed.