Create a view on from the table that converts the date/time field to an int data type in the format that Remedy expects. Then in your view form, create a date/time field and point it to the int column. See the db reference guide on how to convert the data type.
Axton Grams On Dec 21, 2007 11:55 AM, Drew Shuller <[EMAIL PROTECTED]> wrote: > Jorge, Dylan, > > I just ran into this yesterday. I have oracle DATE and a CLOB fields. > Can't do anything about the CLOB except to find out if the data really > exceeds 4000 characters, the limit of VARCHAR. > > You may be able to have your DBA create some code that converts the value > in his DATE column to something that Remedy likes. Off the top of my head, > maybe a character or number field where the data has been converted to > Epoch time. You will need to experiment with the Remedy side of things in > order to tell your DBA exactly what to provide...or someone on this list > can tell us! > > Drew > Tulsa, OK > > > > On Fri, 21 Dec 2007, Wheeler, Dylan wrote: > > > Is the field one of these types? > > Only the following data types are supported in view forms: > > > > * SQL Server-char, varchar, tinyint, smallint, int, text, real, float, > > decimal > > > > You can't use a datetime field from sql. I don't have a sql box I can > > access but if I remember right it keeps a unix timestamp in a varchar > > field and translates that into a human friendly date/time. > > > > > > ------------- > > > > Dylan Wheeler > > Production Control Analyst Principal > > IT Operations > > Downey Savings & Loan Association, F.A. > > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Jorge Polo > > Sent: Friday, December 21, 2007 8:22 AM > > To: arslist@ARSLIST.ORG > > Subject: When I create a View form does not load datetime fields > > > > > > ** > > Hello everyone, > > > > When I provide the database table name > > (DATABASENAME.OWNER.TABLENAME) and click on "Load" to create a view > > form, the datetime fields are missing from the list of loaded fields. > > Can anyone explain how to resolve this problem? Thank you. > > > > > > Our Environment is Windows Server 2003 - Remedy AR System Server > > 6.3 - Microsoft SQL-Server 2000 - Helpdesk 5.6 Application > > > > Portions of this message may be confidential under an exemption > > to Ohio's public records law or under a legal privilege. If you have > > received this message in error or due to an unauthorized transmission or > > interception, please delete all copies from your system without > > disclosing, copying, or transmitting this message. > > __20060125_______________________This posting was submitted with HTML in > > it___ > > > > > > > > This message and any attachments are for the intended recipient(s) only and > > may contain privileged, confidential and/or proprietary information about > > Downey Savings or its customers, which Downey Savings does not intend to > > disclose to the public. If you received this message by mistake, please > > notify the sender by reply e-mail and delete the message and attachments. > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"