Maximum Date Summary Field - Midnight Issues
hey guys! I am having an issue with a date/time summary field. I have a child table with a date/time out field. this is on a report where these show as child records in a report on a main service r...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI'm not sure i 100% understand the issue, but if you want to re categorize the date or the time that a certain timestamp is done, like the edge case of midnight, then you can make a formula field mirror to adjust by formula to 11:59 and based your summary fields on that artificial field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
I want to span midnight for a duration. The duration needs to have the date from the first day but allow total minutes to add for the start time before midnight to the stop time after midnight. I have 2 "time of day" fields to capture the start and stop times and then a duration formula to calculate the total time. This works perfectly until a time spans midnight and then I get a negative number. Do you have any suggestions?
------------------------------
David Isely
------------------------------
------------------------------
David Isely
------------------------------
- MarkShnier__Younot tested by try this
var duration DurationRaw = [TOD End] - [TOD Start];
IF($DurationRaw > Minutes(0), $DurationRaw, Hours(24) + $DurationRaw)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Worked like a charm thank you kindly sir!
------------------------------
David Isely
------------------------------