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

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

Find more posts tagged with

Formulas

Hours and Minutes

Time Calculation

Accepted answers

Paul Newcome

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

=MIN(Modified:Modified) + ""

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.