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...
Solved
Retrieve the most recent date
+4Best answer by TheTimeSavingCo
Hmm, if this is a rollup field this should work fine:
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
+31Hmm, if this is a rollup field this should work fine:
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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.