All SPQuery examples

Query for Date type Column in SharePoint


The above query is to find the items which has Date column with value less than Today's Date. The results will be returned in a Descending manner so you can get the most recently entered items from the List.

Query on Date Yes\No columns :

The Above query is to find the Item which has Current Date(i.e Today's Date) at "Date" column and a Yes at a checkbox column(Yes/No column).

For Detail SPQuery examples Goto :

All SPQuery examples