Retrieve the most recent date

[MarineSorato]

I have a cell containing multiple dates.
I want to have a column retrieving the most recent date from this cell.

Which formula can I use? 

Tried with Max, or even last time modified but didn't do the trick...

[TheTimeSavingCo · Accepted solution]

Hmm, if this is a rollup field this should work fine:

Link to base

If your cell's in a text field this is going to be a lot more difficult though.  You'll need to use a formula field and use DATETIME_PARSE for each date, then use DATETIME_FORMAT to convert it to milliseconds and then use MAX() on that

[MarineSorato]

Merci ! What I was missing was exactly this !