LastModifiedTime managed property inside my Search Result web part will not get updated when editing word document properties

Question

I am working on an on-premises farm 2013. and i have added a Search Result web part, which should show documents from multiple documents libraries. now one of the properties i am showing inside the Search Result Web Part named LastModifiedTime, as follow:-

<mso:ManagedPropertyMapping msdt:dt="string">'ListID','ListItemID','ContentTypeId','FileType','Link URL':'Path','CommentOWSMTXT','BodyOWSMTXT','Property 1':'FileName','Property 2':''*****','Property 7':'LastModifiedTime','Property 8':'EditorOWSUSER','SecondaryFileExtension'</mso:ManagedPropertyMapping>

now i have noted a problem that the LastModifiedTime managed property will not get updated when i edit a word document properties. for example i have the following document which have its modified date = 37 minutes ago inside the actual document library:-

while inside the Search Result web part the LastModifiedTime will be equal to 5 September:-

now for example i click on the document property using the system account and i change one of the document property, where the modifiedBy inside the Search Result web part will be updated but the LastModifiedTime will still be 5 sep.. so users will be confused they will think that the system account have updated the document on 5 Sep, while it was modfied 37 minutes ago ..so not sure what is the problem. keeping in mind that i have uploaded a .png image, where i edit its properties and both the LastModifiedTime & modifed by were updated inside the Search Result web part.. but seems this is problem is happening to word documents and pdf.. did not test for other types..

Answer 1

LastModifiedTime managed property does not always show the modified date value of a list item. The reason behind that is that LastModifiedTime managed propery is mapped to multiple crawled properties as below:

Since its SharePoint, there are multiple timer jobs running internally in the background which affect the modified date values of SharePoint sites, lists, list item etc.

Now you have 2 options:

1) You can re-order these crawled properties and move ows_Modified to the top. After that wait for the full crawl and it will get the modified date/time values. However, I wouldn't recommend it as we would be modifying the OOTB managed property. There is no harm in doing this though.

2) To always get the modified value of a list item only, you should map the ows_Modified crawled property to a managed property like RefinableDateXX. This will always ensure that you get the Modified date time values of a list item. I would recommend using this approach as it doesn't modify the OOTB managed property and would be easier in case of migration.

Now, you mentioned that the value is 1 hour behind, not really sure why its like, it could be due to multiple reasons like daylight savings or Regional settings at the site collection or web application level or some other reason. However, you can try the below work around in your display template.

if (property.managedPropertyName === 'RefinableDate00'){

    var modifiedDate2 = ctx.CurrentItem.RefinableDate00;
    if(modifiedDate2){
        modifiedDate2 = new Date(ctx.CurrentItem.RefinableDate00);
        //set the date time value to 1 hour behind
        modifiedDate2.setHours(modifiedDate2.getHours()-1);
        var formattedDate = String.format("{0:dd}/{0:MM}/{0:yyyy} {0:t}",modifiedDate2);
        console.log(formattedDate);
    }

}

In your html, you can use it as below:

_#= formattedDate =#_

Edit 2 - Not sure why the above didnt work, it worked for me in SP Online. However, i tried the below 2nd approach and it work.

var modifiedDate2 = $getItemValue(ctx, 'RefinableDate00'); 
if(modifiedDate2.value){                        
    var parseDate = new Date(modifiedDate2.value);

    var formattedDate = parseDate.format('dd-MM-yyyy hh:mm');                        
}

References -

Changing date format using javascript

Search returns wrong date (date -1)

SharePoint stores dates in UTC time