Well, It appears that you are pulling the data directly through the DB instead of any Remedy interface. This means that you need to manually translate the character string. Each number you are looking at is Unix Epoch (Number of seconds since Jan 1 1970)...so you will need to write a function to convert that to a format you consider better
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Julio Cesar Villarreal Gonzalez Sent: Wednesday, May 02, 2007 8:12 AM To: arslist@ARSLIST.ORG Subject: Diary Field, Convert Seconds to Date Happy day listers, my question are the next: I have a Diary field, but the information is showed in Reporting Services, in seconds, like a string, my question is: How can I show this information in Date Format, like appear in remedy user tool? I need display this information in the web for my enterprise. Example: 1177342799.RAUL SANCHEZ.INSTALAR BASE DE DATOS.1177344243.Demo.1 HORAS xx.1177344591.RAUL SANCHEZ.1 HORAS xxx.1177344665.RAUL SANCHEZ.1 HORAS xxxx.1177348153.RAUL SANCHEZ.1 HORAS a.1177350824.RAUL SANCHEZ.1 HORAS B.1177350883.RAUL SANCHEZ.1 HORAS C.1177350955.RAUL SANCHEZ.2 HORAS D.1177352557.RAUL SANCHEZ.2 HORAS E.1177352655.RAUL SANCHEZ.3 HORAS F.1177364526.RAUL SANCHEZ.1 HORAS g.1177364574.RAUL SANCHEZ.1 HORAS h.1177364976.RAUL SANCHEZ.1 HORAS i.1177365034.RAUL SANCHEZ.1 HORAS j.1177365334.RAUL SANCHEZ.1 HORAS k.1177365378.RAUL SANCHEZ.3 HORAS l.1177365445.RAUL SANCHEZ.1 HORAS m.1177365460.RAUL SANCHEZ.1 HORAS n.1177365514.RAUL SANCHEZ.1 HORAS o.1177365535.RAUL SANCHEZ.1 HORAS Thanks, Julio Cesar Remedy 6.3, Solaris, Oracle 10i. ............................................................................ ............... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ............................................................................ ............... ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
