Skip to main content
🚨 A Microsoft API issue is affecting MacroView products. Read more.

Search

How can we help?

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

Colin Titmuss
  • Updated

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. 

See also...

Search configuration for SharePoint Online (Office 365) and On-Premises (Client Side Only)