MIN/MAX with Date and Time (Modified Date Column)

Jim B

Hi all,

This should be straightforward but I am stumped!

How do I get the earliest (or latest) value including time from a Modified Date system column?

e.g.

I can get the date if I define my output column as type Date and use a simple MIN/MAX but this means the time is ignored.

I thought about breaking the time and the date out into separate columns and using TIME formula and then MIN/MAX with COLLECT to do a multi-criteria search. But it seems awfully fiddly. Also a MIN with TIME is doing strange things with roundings.

Anyone got any tips?

Many thanks in advance.

Jim

Paul Newcome

You can put the output in a text/number field and convert the output into a text string.

=MIN(Modified:Modified) + ""

Paul Newcome

You can put the output in a text/number field and convert the output into a text string.

=MIN(Modified:Modified) + ""

Jim B

Neat! Thank you @Paul Newcome. Always so helpful.

Paul Newcome

Happy to help. 👍️