Hi Russ,

Thank you for the details provided.

Could you please do the following:

1) Create new document library;

2) Add new column with DateTime type and "Date & Time" format for the values;

3) Upload any document (Word, Excel, txt) to this library using standard IE interface;

4) Put some value to the column from step # 2;

5) Create new Managed property, map it to the column from step # 2;

6) Reset Index under "Central Administration - Search Service Application: Search Administration";

7) Start all crawls, wait until it finished and execute the search against the library from step # 1.

Could you please provide XML results in this case?

The search is performed within SharePoint 2010. The XML I'm referring to is that which SP is returning. Here is an example of one such Result element (more below):

<?xml version="1.0" encoding="utf-8" ?>

<All_Results>

<Result>

<id>1</id>

<workid>542</workid>

<rank>79717428</rank>

<title>xxxxxxxx xxx xxxxxxxxxxxx</title>

<author_multival>Leska, Craig</author_multival>

<author>Leska, Craig</author>

<size>1230848</size>

<url>http://jobportal-hun-arc/Huntair Dropbox/FW_ 1032 xxxxxxx xxxxx_1qu1kk9o.msg</url>

<urlEncoded>http%3A%2F%2Fjobportal%2Dhun%2Darc%2FHuntair%20Dropbox%2FFW%5F%201032%20Kaiser%20Coils%5F1qu1kk9o%2Emsg</urlEncoded>

<description></description>

<opmto>John Albert</opmto>

<opmfromname>Tim Lema</opmfromname>

<opmreceived>6/8/2006</opmreceived>

<opmattachmentnames>SCAN1677_000.pdf</opmattachmentnames>

<opmattachmentcount>1</opmattachmentcount>

<write>7/2/2012</write>

<sitename>http://jobportal-hun-arc/Huntair Dropbox</sitename>

<collapsingstatus>0</collapsingstatus>

<hithighlightedsummary>

Tom McClung; Jim Tarala; Kaufman, Jeff <ddd /> 2006-06-08T12:11:20Z <ddd /> Attached is Kurt Schultheis’ xxxxxx quote with the coil construction data in the attachment. <ddd /> Subject: RE: <c0>1032</c0> xxxxxxxxxxxx <ddd />

</hithighlightedsummary>

<hithighlightedproperties>

<HHTitle>

FW: <c0>1032</c0> xxxxxxx xxxxx

</HHTitle>

<HHUrl>

http://jobportal-hun-arc/Huntair Dropbox/FW_ <c0>1032</c0> xxxxxx xxxxx_1qu1kk9o.msg

</HHUrl>

</hithighlightedproperties>

<contentclass>STS_ListItem_DocumentLibrary</contentclass>

<isdocument>True</isdocument>

<picturethumbnailurl></picturethumbnailurl>

<popularsocialtags />

<picturewidth>0</picturewidth>

<pictureheight>0</pictureheight>

<datepicturetaken></datepicturetaken>

<serverredirectedurl></serverredirectedurl>

<fileextension>MSG</fileextension>

<ows_metadatafacetinfo></ows_metadatafacetinfo>

<imageurl imageurldescription="Mail">/_layouts/images/icmsg.png</imageurl>

</Result>

Notice is a formatted date value, but this is actually a managed property in the search Metadata, which I have mapped to Crawled property ows_EmDateReceived, and the type is "Date and Time". The other properties are all displaying fine, but are text strings for the most part - hard to compare them to a DateTime field. The SharePoint data includes the Time portion of the Date and Time representation of the values. If the raw search results do not contain the Time, then this cannot be used to sort the rows by this value.

Russ

Hi Russ,

thank you for your question!

To answer it, could you please provide more details about the issue?

Where do you perform the search?

Clarify what XML file is used and where?

Provide step-by-step screenshots of the process

Please feel free to send your answer to my e-mail: ilia (at) scinaptic.com

Hope to hear from you soon.