Matthew Knott - Blog

Here's an example of how I query a SharePoint 2007 Event List for events that occur after the current date, using the SPQuery class.

using (SPSite site = new SPSite(serverRootURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
SPList eventsList = web.Lists["Events"];
SPQuery eventQuery = new SPQuery();
eventQuery.Query = "<Where><Gt><FieldRef Name='EventDate'/><Value Type='DateTime'>" + DateTime.Now.ToString("yyyy-MM-dd") + "</Value></Gt></Where>";
SPListItemCollection eventItems = eventsList.GetItems(eventQuery);
foreach (SPListItem eventItem in eventItems)
{
//List Output Here
}
}
}

The DateTime value needs to be in the yyyy-mm-dd format for this to work.