Need MAX Date, and MAX Time, for specific Location

I need to be able to parse out an entry based on Latest Entry, most often this entry will have an open and close., sometimes multiple times a day. I want to be able to have a separate sheet that displays the most recent event. Thought I had it, but realized the sheet stopped at the first MAX date and did not reference the most recent entry. Created a formula to take the DATE field and display as 230125 and then added the TIME so the final looks like 2301250825, works great to sort but am getting a "0" any time I try to find a max value. Is it because it is a Formula? note in the example below I did have +"-"+ between date and time.

The formula did work to pull the most recent date, its just that this Run was opened at 1107 and the formula did not decipher that....

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @SkiPatrolScott

Remove the dash between the date and time, then wrap your entire parsing formula within a VALUE(). This should force your textstring to behave as a number. Then your MAX/Collect should work.

Kelly

All comments

Kelly Moore

Hey @SkiPatrolScott

Remove the dash between the date and time, then wrap your entire parsing formula within a VALUE(). This should force your textstring to behave as a number. Then your MAX/Collect should work.

Kelly

SkiPatrolScott

THANKS!, come visit us and I will show you the product in action!

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.