Use date and time in CAML query

On a SharePoint site I wanted to use a CAML query to only see all the list items of a particular list filtered on date AND time. First I thought this was impossible till I found on the internet the following string “IncludeTimeValue=”TRUE”

I used it like this:

<Leq>
         <FieldRef Name=’StartDate’ />
         <Value Type=’DateTime’ IncludeTimeValue=”TRUE”><Today /></Value>
</Leq>

Tags: CAML