Aug 21, 2024 02:53 AM
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! Go to Solution.
Aug 21, 2024 02:59 AM - edited Aug 21, 2024 03:02 AM
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
Aug 21, 2024 02:59 AM - edited Aug 21, 2024 03:02 AM
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
Aug 21, 2024 03:13 AM
Merci ! What I was missing was exactly this !