Sort DateTime Field

Question

Help me!
I wish to take from the adjusted list the certain values on field DateTime.
However, the inquiry sorts data only by date of, without consideration time. How it is possible to consider both date, and time?

Code Snippet

<Where>
 <Eq>
  <FieldRef Name='dateTimeField' />
  <Value Type='DateTime'>
   2008-03-24T12:00:00Z
  </Value>
 </Eq>
</Were>

Enter:

1. 3/24/2008 12:00:00 AM
2. 3/24/2008 5:00:00 PM
3. 3/24/2008 12:00:00 AM

Answer 1

add in the IncludeTimeValue='TRUE'  property to the Value type. (like below)

 

Code Snippet

<Where>
 <Eq>
  <FieldRef Name='dateTimeField' />
  <Value Type='DateTime'  IncludeTimeValue='TRUE'>
   2008-03-24T12:00:00Z
  </Value>
 </Eq>
</Where>

 

 

Answer 2

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Answer 3

Thanks Gavin! If only I had known before... I've written a blog entry about this one:

http://www.wirwar.com/blog/2008/07/30/sharepoint-frustrations-1-the-undocumented-includetimevalue-caml-attribute/