Midge,
What are the database settings for TIME FORMAT and TIME SEQUENCE?
Could you give me an example, data types, scenario or fake values for calculations?
Very Best R:egards,
Razzak.
At 02:38 PM 8/24/2004 -0600, Nielsen Midge D wrote:
I tried that too.
-----Original Message----- From: [EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Tuesday, 24 August, 2004 14:32 To: [EMAIL PROTECTED] Subject: [RBG7-L] - Re: Null times
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?
