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.
======================================================================
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
