All: For anyone who might need it:
The topic of calculating shift time across midnight boundaries came up in early March.
Albert Berry introduced DATETIME math, inspiring replacement of my complicated [ Day1Hours + DaysBetween + LastDayHours ] code with:
SET VAR vDateTime_PREV = (DATETIME(.vDate_PREV , .vTime_PREV )) SET VAR vDateTime_CURR = (DATETIME(.vDate_CURR , .vTime_CURR )) SET VAR vElapsed_SECONDS = (.vDateTime_CURR - .vDateTime_PREV ) SET VAR vElapsed_Dec_HOURS = (ROUND((.vElapsed_SECONDS / 3600),3)) SET VAR vElapsed_Dec_DAYS = (ROUND((.vElapsed_Dec_HOURS/24),3)) SET VAR vElapsed_Cal_DAYS = (.vDate_CURR - .vDate_PREV ) Thanks again, Albert. Bruce Chitiea SafeSectors, Inc. 909.238.9012 Mobile -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
