Display and Sort on Date and Time Managed Property

Question

I'm using a CoreResultsWebPart to display the latest articles in a short list. To display the last modified Date and Time I've created a Managed Property called LastModifiedDateTime (I'm aware of the existings of LastModifiedTime, but this can't be used.) This works, but not with the expected results, since it only displays the Date and not the Date AND Time.

Creating the Managed Property:

1. Add New Managed Property

   Property name: LastModifiedDateTime
   Include values from a single crawled property based on the order specified
   Has Multiple Values > Unchecked
   Crawled properties mapped to this managed property:
   Basic:14(Date and Time)
   Basic:16(Date and Time)
   ows_Modified(Date and Time)
   lastaccessed(Date and Time)
   Allow this property to be used in scopes
   Add managed property to custom results set retrieved on each query. Note: Only the first 2 kilobytes of data is available for display by default. > Checked
   

2. Start full crawl

Display the Managed Property:

1. Edit CoreResultsWebPart
2. Add Fetched Properties
3. Add XSL with the XSL-editor:

XSL

<xsl:for-each select="node()">
    Property:<xsl:value-of select="name()"/> |
    Value:<xsl:value-of select="."/><br/>
</xsl:for-each>

It displays the following result:

... Property:lastmodifieddatetime | Value:28-11-2012 ...

While the expected result was:

... Property:lastmodifieddatetime | Value:28-11-2012 10:34 ...

Any ideas?

Thanks in advance

Answer 1

you can create a calculated column(test) with last updated column, do full crawl and find the crawl property ows_test and map that to your new managed property. and specify the new managed property(text) as column in your sortablecoreresultswebpart. you will get something like this

1 12/5/2012 datetime;#2012-12-05T16:26:10Z

you can use xslt to reformat the date and time . hope this helps

Answer 2

Just because the crawled properties you have mapped to your managed property are of the type "Date and Time" does not mean that they actually have a value that includes a date and time.

Since your mapped property is getting its value from the crawled properties based on their order in the list, I would start by juggling the order of the properties in the list and see if having one of the other crawled properties first (instead of Basic:14) gives you the data you are looking for.

According to this technet article, Basic:14 is mapped to LastModifiedTime, which you said is not working for you.