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...
Page 1 / 1
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
Merci ! What I was missing was exactly this !
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.