At 02:31 PM 10/17/2002 -0400, you wrote:
Dear MikeApparently there is a 24 hour maximum to this calculation.
Dear Randy; The reason being that all we are doing is pulling out the TIME portion of the DATETIME value. Therefore, the DATE differences do not come into play. For that, you would follow Bill's example of: SET VAR vLapsedSeconds INT = (.vDateTime2 - .vDateTime1) Then, take your result (in seconds), and divide by 3600 to get hours, or utilize the MOD function to get hours and the remaining minutes and seconds. This will result in the total difference between the two DATETIME arguments. Steve's original question dealt only with time, so that is why I used the TEXTRACT function. Best Regards, Mike ------------------------------------------- Michael Willochell Director, Customer Support R:BASE Technologies, Inc. 3935 Old William Penn Highway Murrysville, PA 15668-1854 Phone: 724-733-0053 FAX: 724-733-0196 URL: www.rbase.com Sales: [EMAIL PROTECTED] Support: [EMAIL PROTECTED] ------------------------------------------- ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
