I'm creating a Time Out column wherein it stores the Modified Date/Time of a list. However, I just want to get only the latest Modified Date/Time that is the same Date as the Created Date.


Created Date/Time = 11/12/2015 10:43 AM

1st Modified Date/Time = 11/12/2015 12:51 PM

2nd Modified Date/Time = 11/12/2015 5:05 PM <---This is the Date/Time I need to keep.

3rd Modified Date/Time = 11/13/2015 8:20 AM 

I'm stuck in just getting the Modified Date/Time:

=IF(Modified=Created,Modified, " ")

I'm fairly new to Sharepoint admin, is there any additional functions I can use to improve the above formula without using powershell?

  • 2
    Calculated column value is evaluated every time item is modified based on item field values. For this scenario it requires access to previous versions of item in calculation which doesn't look feasible. I guess you will have to try custom field / event receivers / workflows. – Prakash Nov 13 '15 at 6:37

ListItems have no clue about its History so a Calculated Column Formulas only calculate with the last Created and Modified values.

You have to put your logic in a SharePoint Designer (free tool) Workflow:

  • Add a column TimeOutDate

Your workflow should do (something like):

  • On item change
  • check if todays date is the created date
  • if Yes, write modified to TimeOutDate
  • if No, do nothing

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.