What might have worked is if you mapped it to an integer field and then used that integer field to set to the date field. I haven't tried that so don't be surprised if you get a data type mismatch if you try to set the integer field to the the date field.. but worth a try.. Joe
----- Original Message ---- From: "Garrison, Sean (Norcross)" <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, June 16, 2008 3:40:05 PM Subject: Resolved: AIE and Importing Date Fields Question ..... ** I was able to figure it out. It isn't the best solution but it works … I used the "SQL" option and did the following: SQL|SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') + ((<INSERT DATE FIELD HERE> -5)/(60*60*24)),'MM/DD/YYYY HH24:MI:SS') FROM <INSERT FORM VIEW NAME HERE> WHERE INSTANCE_ID = '$ INSTANCE_ID $' Michelle … thank you for your input. Unfortunately it gave me a mapping error when I tried it. Thanks, Sean From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michelle L Sent: Monday, June 16, 2008 3:06 PM To: [email protected] Subject: Re: AIE and Importing Date Fields Question ..... ** Hi, Sean: Someone feel free to correct me if I am wrong. You should be able to import an integer into a Remedy Date field since (as you acknowledged) it is stored as an integer. It will automatically be displayed as a Date when viewed through the GUI. At least I've done that in the past. Have you tried that? Hope that helps, Michelle "Garrison, Sean (Norcross)" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 06/16/2008 12:12 PM Please respond to [email protected] To [email protected] cc Subject AIE and Importing Date Fields Question ..... ** I am using AIE 7.1 to connect to an Oracle Remedy Database. Which means that dates are stored as integers and not as actual "Date" fields. How would I use AIE to import an Oracle date field (Remember it was created by remedy as an integer field and not a date field) into a Remedy date field? It is my understanding that AIE is looking for a string to represent the date like "01/01/08 00:00:00". Any help would be appreciated. Thanks, Sean __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ====================================================================== Confidentiality Notice: The information contained in and transmitted with this communication is strictly confidential, is intended only for the use of the intended recipient, and is the property of Countrywide Financial Corporation or its affiliates and subsidiaries. If you are not the intended recipient, you are hereby notified that any use of the information contained in or transmitted with the communication or dissemination, distribution, or copying of this communication is strictly prohibited by law. If you have received this communication in error, please immediately return this communication to the sender and delete the original message and any copy of it in your possession. ===================================================================== _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
