Currently using SP Online Office 365
For simplicity let's say my list has 5 columns, The Lookup Date is linked to the lookup title so it pulls through the corresponding date based which title/s were pulled through the TitleLookup.
I am trying to look at TitleLookup:Date, separate the multiple values, find the largest value, and place that value in the Latest Date column.
Title - Date - TitleLookup - TitleLookup:Date - Latest Date
test - 1/1/10
Test2 - 2/2/12
Test 3 - 3/3/13 - Test;Test2 - 1/1/10;2/2/12 - 2/2/12
Preferably I would like to do this without any JQuery or the like, perhaps a workflow, that can log the lookup dates individually to its history and then compare them but while I'm ok at building basic workflows this is something a little more challenging for me.