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: [email protected] 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"
