It sounds like you are using something outside of Remedy either as an application, or a reporting tool. You are seeing seconds from 12:00:00am 1/1/1970. If you are using Crystal Reports, then there are two possible solutions. Either start using the Remedy ODBC Driver (converts to time internally), or there is a group of utilities from Elegant Software Solutions to make the conversion for you. If this is a web based application, or another outside of Crystal, then it's a matter of parsing the string, making the conversion (adding seconds to 1/1/70 - then correcting for hours from GMT) , and pasting the data back on the page or application. In Microsoft Products I think you'll need to use the dateadd function.
Hope this helps
John Gould
Senior Applications Developer
Senior Remedy Administrator
Cybear Inc.
Boca Raton, FL
jgould@mediaone.net
jgould@cybear.com
At 09:19 AM 6/28/00 +1000, you wrote:
>Angela,
>
>I'm not sure I understand. I have filters that set Diary fields with things like:
>
>"Date Field: " + $Date Field$
>
>and then in the field would appeare (for example)
>
>Date Field: 28/06/00 09:15:22
>
>Since this is set by a filter the date format is determined by the ARDATE format on the server.
>
>
>And if your talking about the timestamp that appears at the top of each entry that uses the date settings on the client. (Regional Settings and DispDateMode variable in ar.ini).
>
>Could you be more speciic on the problem you are having?
>
>
>regards, Barry
>
>-----Original Message-----
>From: ZZG-Problemmanagement-IZB
>[ mailto:ZZG-Problemmanagement-IZB@IZB.DE]
>Sent: Tuesday, 27 June 2000 20:46
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Time in Diary field
>
>
>HI
>Does anyone know if it is possible in a diary field to have the date
>correctly formatted from seconds into real time? We have a diary field that
>contains the time/s of the solution/s but it is displayed in seconds is
>there anyway to change this?
>
>TIA
>> ______________________________________
>> Angela Rowand
>>
>Informatik Zentrum Bayern GmbH & Co. KG.
>Karolinenplatz 1
>80333 München
>* (089)2171-5992
>* (089)2171-5383
>* mailto:Angela.Rowand@izb.de
>* http://www.izb.de
>
>
>
>
>EOM
>
>NOTICE - This message contains information intended only for the use of the addressee named above. It may also be confidential and/or privileged. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify postmaster@bhp.com.
>
>
>
>
John Gould
Senior Developer
Senior Remedy Administrator
Cybear Inc.
Boca Raton, FL
jgould@cybear.com
jgould@mediaone.net
Previous Topic
Index