Delete the field from your Remedy form and create a Date/Time field. On the database tab fill out the Table and Name information as it is in the database view.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Thursday, July 31, 2008 4:24 PM To: [email protected] Subject: View form: showing a NUMBER(15,0) field as DateTime in Remedy Hi: I have created a view form over a table in the database.I have a couple of fields in that table which are NUMBER(15,0) that essentially holds the unix expoch time. Is there anything I can do in the view to those fields so they show up like a normal date/time from User client? Thanks Ravi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

