Do you have zero set on in the 7.x database? SET ZERO ON This forces R:Base to treat nulls as zeros when calculating.
--- Nielsen Midge D Contr 388 RANS/JT3 <[EMAIL PROTECTED]> wrote: > I have a database that I am converting to 7.x from 6.5++. I let the user > input utilization times if a mission is complete. If they insert a > utilization start time, but not a utilization stop time or vise versa, the > remaining time is inserted as a null value. > > I compute the utilized hours by the following formula, so that the number of > hours is always positive. > > Util_hr = > (IFLT((UTIL_STOP-UTIL_START),0,(((UTIL_STOP-UTIL_START)+86400)/3600),(UTIL_S > TOP-UTIL_START)/3600)) > > R:Base 6.5++ looks at the missing time and assumes it is 2400 hours, which > is correct. R:Base 7.x looks at the time as null and does not compute a > utilized hour. > > Can anyone help me figure out how to get it to compute the utilized hours? > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
