Microsoft Developer Network > SharePoint Products and Technologies Forums > SharePoint - Development and Programming > Sort DateTime Field

Sort DateTime Field

Wednesday, March 26, 2008 10:07 AMNevrotik

0
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
- Reply
- Quote

Answers

Wednesday, March 26, 2008 10:10 AMGavin Morgan

0
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>
- Reply
- Quote

All Replies

Wednesday, March 26, 2008 10:24 AMNevrotik

0
Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- Reply
- Quote
Tuesday, August 05, 2008 3:01 PMLZandman

0
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/
- Reply
- Quote

Need Help with Forums? (FAQ)