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
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!