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?