Midge,
SET EQNULL ON
Have fun!
Very Best R:egards,
Razzak.
At 02:08 PM 8/24/2004 -0600, Nielsen Midge D 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?
