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
MarkShnier__You
Qrew Legend
Qrew LegendYou can make a Duration field
[my time of day field] - ToTimeOf Day("12:00 am")
I'm assuming that you can do a summary Maximum on that. Then if you need to convert that back to a time of day field you could make a new field
ToTimestamp(Today(), ToTimeOfDay("12:00 am")) + [My summary Max duration field]
- ToTimestamp(Today(), ToTimeOfDay("12:00 am"))
I don't think you are allowed to add duration to a time of day field. It's a vague memory but I did not have time to test.
.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
[my time of day field] - ToTimeOf Day("12:00 am")
I'm assuming that you can do a summary Maximum on that. Then if you need to convert that back to a time of day field you could make a new field
ToTimestamp(Today(), ToTimeOfDay("12:00 am")) + [My summary Max duration field]
- ToTimestamp(Today(), ToTimeOfDay("12:00 am"))
I don't think you are allowed to add duration to a time of day field. It's a vague memory but I did not have time to test.
.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------