re,
a little expression
* 11:31:41 16 Mar 2007 timedate() sample
* A = TIMEDATE() 1
* B = TIMEDATE() 2
*-----------------
BD = (ICONV(OCONV(A,'G1 3'),'D') * 86400)
ED = (ICONV(OCONV(B,'G1 3'),'D') * 86400)
BT = ICONV(OCONV(A,'G0:3'),'MTS')
ET = ICONV(OCONV(B,'G0:3'),'MTS')
DIFF = (ED - BD ) + (ET - BT)
you can do it with a IType
I hope this help...
Manu
----- Original Message -----
From: "Marco Manyevere" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, March 16, 2007 11:24 AM
Subject: [U2] Difference between two TIMEDATES in seconds
Hello everyone,
Can someone help me with this. I need a way to calculate the difference
between two TIMEDATE() and return the results in seconds. The biggest
difference I expect between the two time dates is 100 days.
Thanks and regards, Marco.
___________________________________________________________
The all-new Yahoo! Mail goes wherever you go - free your email address
from your Internet provider. http://uk.docs.yahoo.com/nowyoucan.html
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
