Sort DateTime FieldHelp me! <br>I wish to take from the adjusted list the certain values on field DateTime. <br>However, the inquiry sorts data only by date of, without consideration time. How it is possible to consider both date, and time?<br><br> <div style="text-align:left"> <div class=codeseg> <div class=codecontent> <div class=codesniptitle><span style="width:100%">Code Snippet</span></div> <p>&lt;Where&gt;<br> &lt;Eq&gt;<br>  &lt;FieldRef Name='dateTimeField' /&gt;<br>  &lt;Value Type='DateTime'&gt;<br>   2008-03-24T12:00:00Z<br>  &lt;/Value&gt;<br> &lt;/Eq&gt;<br>&lt;/Were&gt;</p></div></div><br>Enter:<br> <ol> <li>3/24/2008 12:00:00 AM <li>3/24/2008 5:00:00 PM <li>3/24/2008 12:00:00 AM</li></ol></div>© 2009 Microsoft Corporation. All rights reserved.Tue, 05 Aug 2008 15:01:40 Zf891563a-eea2-4525-8a88-b23f0d435930http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#f891563a-eea2-4525-8a88-b23f0d435930http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#f891563a-eea2-4525-8a88-b23f0d435930Nevrotikhttp://social.msdn.microsoft.com/Profile/en-US/?user=NevrotikSort DateTime FieldHelp me! <br>I wish to take from the adjusted list the certain values on field DateTime. <br>However, the inquiry sorts data only by date of, without consideration time. How it is possible to consider both date, and time?<br><br> <div style="text-align:left"> <div class=codeseg> <div class=codecontent> <div class=codesniptitle><span style="width:100%">Code Snippet</span></div> <p>&lt;Where&gt;<br> &lt;Eq&gt;<br>  &lt;FieldRef Name='dateTimeField' /&gt;<br>  &lt;Value Type='DateTime'&gt;<br>   2008-03-24T12:00:00Z<br>  &lt;/Value&gt;<br> &lt;/Eq&gt;<br>&lt;/Were&gt;</p></div></div><br>Enter:<br> <ol> <li>3/24/2008 12:00:00 AM <li>3/24/2008 5:00:00 PM <li>3/24/2008 12:00:00 AM</li></ol></div>Wed, 26 Mar 2008 10:07:06 Z2008-03-26T10:23:41Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#a9d2de8d-b81d-4ff1-9925-d1f2b2f31a9dhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#a9d2de8d-b81d-4ff1-9925-d1f2b2f31a9dGavin Morganhttp://social.msdn.microsoft.com/Profile/en-US/?user=Gavin%20MorganSort DateTime Field<p align=left><font face=Arial size=2>add in the IncludeTimeValue='TRUE'  property to the Value type. (like below)</p></font> <p> </p> <p align=left> <div class=codeseg> <div class=codecontent> <div class=codesniptitle><span style="width:100%">Code Snippet</span></div> <p align=left>&lt;Where&gt;<br> &lt;Eq&gt;<br>  &lt;FieldRef Name='dateTimeField' /&gt;<br>  &lt;Value Type='DateTime'  <font color="#ff0000">IncludeTimeValue='TRUE'</font>&gt;<br>   2008-03-24T12:00:00Z<br>  &lt;/Value&gt;<br> &lt;/Eq&gt;<br>&lt;/Where&gt;</p> <p align=left> </p></div></div> <p align=left> </p> <p></p><font color="#a31515" size=2></font>Wed, 26 Mar 2008 10:10:50 Z2008-03-26T10:23:41Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#2ded80c7-04ca-4c42-b841-20c1a61e2dd5http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#2ded80c7-04ca-4c42-b841-20c1a61e2dd5Nevrotikhttp://social.msdn.microsoft.com/Profile/en-US/?user=NevrotikSort DateTime FieldThanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Wed, 26 Mar 2008 10:24:06 Z2008-03-26T10:24:06Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#6f49f065-30fe-4f11-9705-a8b84abab26bhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f891563a-eea2-4525-8a88-b23f0d435930#6f49f065-30fe-4f11-9705-a8b84abab26bLZandmanhttp://social.msdn.microsoft.com/Profile/en-US/?user=LZandmanSort DateTime Field Thanks Gavin! If only I had known before... I've written a blog entry about this one:<br><br><a href="http://www.wirwar.com/blog/2008/07/30/sharepoint-frustrations-1-the-undocumented-includetimevalue-caml-attribute/">http://www.wirwar.com/blog/2008/07/30/sharepoint-frustrations-1-the-undocumented-includetimevalue-caml-attribute/</a>Tue, 05 Aug 2008 15:01:40 Z2008-08-05T15:01:40Z