'Received Time' column in search results is displayed in US format or with day and months transposed

Issue

The Received Time displayed for emails in search results is shown in US format or with the data and month transposed.

Applies to:

MacroView DMS
MacroView DMS Pro
MacroView Industry Solutions
SharePoint Online (Office 365)

Background

If the managed property configured for mvReceivedTime on SharePoint Online is of type RefinableDate instead of RefinableDateSingle the date is returned in the search results as a string instead of a date time value and cannot be converted correctly to reflect the local time of the user or the regional settings of the site where the file is stored.

Resolution

Use a RefinableDateSingle managed property in SharePoint Online for mvReceivedTime instead of a RefinableDate managed property.

Inbuilt managed property: RefinableDateSingle00
Type: Date and Time
Map crawled property: ows_mvReceivedTime
Alias (Case sensitive): mvReceivedTime

Note: Custom dates in search results are returned in UTC and then DMS converts them to the local time zone of the user without considering the time zone of the SharePoint site where items are stored. Therefore, the date shown in search results columns might differ from the date shown in the Properties dialog and file list in Browse mode if the time zone of the site and the user's local time zone are not the same.

Search

How can we help?

Issue

Applies to:

Background

Resolution

See also...