Here's the formula I use..
dateadd("s",({HPDHELPDESK.CLOSEDDATE} - 18000),datetime(1970,1,1,0,0,0))
The 18000 get's all time back to EST and the latter part provides the date to start from.
Jason
From: Action Request System discussion list(ARSList) on behalf of Kaiser, Norm E CIV USAF 96 CG/SCTA
Sent: Wed 12/21/2005 2:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Seconds to date...
**
Try using DATEADD(datepart, number, date), where datepart = SS, number = the number of seconds shown in the field in question, and date is 1/1/1970.
Hope that helps,
Norm
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rusconi, Ignacio (I.)
Sent: Wednesday, December 21, 2005 11:49 AM
To: arslist@ARSLIST.ORG
Subject: Seconds to date...
Hi.
Im trying to make a report within Crystal Report.
I need a formula to converts seconds to Date.
Does anybody now how?
Thanks
REMEDY 6.0
Crystal 9.0
SQL 2000
Ignacio G. Rusconi
Data Base Administrator
Ford Argentina-TeleTech
:.4756-9367.:
*irusconi@ford.com
*ignacio.rusconi@teletech.com.ar
Web. http://pacheco.ba.ford.com/pl/9898
¿Sentiste un Ford últimamente?
STRICTLY CONFIDENTIAL. The contents of this e-mail and any attachments are strictly confidential and property of Ford Argentina S.C.A. They may not be used or disclosed by someone who is not a named recipient. If you have received this e-mail in error please notify the sender by replying to this email inserting the word "Misdirected" as the message and delete the present message.
This posting was submitted via the Web interface This posting was submitted via the Web interface
----Notice Regarding Confidentiality----
This email, including any and all attachments, (this "Email") is intended only for the party to whom it is addressed and may contain information that is confidential or privileged. Sierra Systems Group Inc. and its affiliates accept no responsibility for any loss or damage suffered by any person resulting from any unauthorized use of or reliance upon this Email. If you are not the intended recipient, you are hereby notified that any dissemination, copying or other use of this Email is prohibited. Please notify us of the error in communication by return email and destroy all copies of this Email. Thank you.
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
Previous Topic
Index