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....
Best Answer
-
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
Answers
-
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
-
THANKS!, come visit us and I will show you the product in action!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!