Dear Mike
Apparently there is a 24 hour maximum to this
calculation.
The following values were calculated using R:Base 2000
v6.5++ BUILD 1.859xRT03:
v1='08/09/95 12:15:30.123', v2a='08/10/95 13:15:30.123',
v3a= 3600
v1='08/09/95 12:15:30.123', v2b='08/11/95 13:15:30.123',
v3b= 3600
v1='08/09/95 12:15:30.123', v2c='08/12/95 13:15:30.123',
v3c= 3600
SET VAR vElapsed = (RTIME(0,0,.v3)) will return the
erroneous result 1:0:0.
It is erroneous because it suggests that only one hour has
elapsed even though
for the second and third instances, the elapsed time should
be 25:0:0 and 49:0:0
respectively.
Randy Peterson
> SET VAR v1 DATETIME = '08/09/95 12:15:30.123'
> SET VAR v2 DATETIME = '09/19/95 13:15:30.123'
> SET VAR v3 INTEGER = ((TEXTRACT(.v2)) - (TEXTRACT(.v1)))
>
> This will return a value of 3600 in variable v3. This is
your difference in seconds.
>
> You can expand things further by using the RTIME function
to change it into hours, minutes and seconds.
>
> Best Regards,
>
> Michael Willochell
================================================
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/
