Max Time in Child Records
Anyone have a work around to get the Max time from a child record? Maximum Summary field does not work on times, only numbers and dates. There must be a work around I am not thinking of? Maybe con...
Forum Discussion
Mike,
I tested @Mark Shnier (Your Quickbase Coach)'s suggestion.
Here is my Child Table Data
Then my Parent Record sees this
So then the last step is to convert the Duration back into Time on the Parent Record with a second Formula field.
Good suggestion by Mark as always. I will have to remember this for the future.
------------------------------
Don Larson
------------------------------
I tested @Mark Shnier (Your Quickbase Coach)'s suggestion.
Here is my Child Table Data
Then my Parent Record sees this
So then the last step is to convert the Duration back into Time on the Parent Record with a second Formula field.
Good suggestion by Mark as always. I will have to remember this for the future.
------------------------------
Don Larson
------------------------------
Also confirming this worked great. Additionally, to change back to Time, I just needed a snip of Marks code:
ToTimeOfDay("12:00 am")) + [My summary Max duration field]
------------------------------
Mike Tamoush
------------------------------
ToTimeOfDay("12:00 am")) + [My summary Max duration field]
------------------------------
Mike Tamoush
------------------------------
