Marco, BEG.TIMEDATE = TIMEDATE() END.TIMEDATE = TIMEDATE()
BEG.TIME = ICONV(FIELD(BEG.TIMEDATE, ' ', 1, 1), 'MT') BEG.DATE = ICONV(FIELD(BEG.TIMEDATE, ' ', 2, 3), 'D') END.TIME = ICONV(FIELD(END.TIMEDATE, ' ', 1, 1), 'MT') END.DATE = ICONV(FIELD(END.TIMEDATE, ' ', 2, 3), 'D') ET = END.TIME - BEG.TIME + (END.DATE - BEG.DATE) * 86400 This assumes TIMEDATE() outputs in the format "hh:mm:ss dd mmm yyyy". Adjust the code if your system is configured differently. Is this what you are looking for? Perry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: Friday, March 16, 2007 6:25 AM To: [email protected] 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/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
