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
Check out the Formula Handbook template!