If the XMLGateway you refer to is the one I see advertized on the list periodically, I presume it will have the ability to truncate the 00:00:00.0, and put it in a format that Remedy will understand.
_____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of AMEY BHOSALE Sent: Thursday, September 03, 2009 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: Date Time Field Limitation Issue in Remedy restricted to Jan 2038 ** Hi, But the thing is we have an Integration from Remedy with the Trade Database where all the details are obtained like Trade Date and Maturity Date so the format in which the value in stored in their database is yyyy-MM-dd hh:mm:ss. So there is an Xmlgateway integrated with our Remedy Application which contains the server details of this Trade Database where the stored procedure is executed to pull the Trade Date , Maturity Date values. So the Xmlgateway receives the value from Trade Database in yyyy-MM-dd hh:mm:ss format and now this when comes into Remedy will only be correct is the value is till Jan 2038 and if beyond that then it will set to 1/1/1970. I tried using Date field but the value gets stored as in BC format. for e.g. actual value in Trade Database => 2039-02-14 00:00:00.0 data received in Xmlgateway => 2039-02-14 00:00:00.0 But if i create a date field and tried storing this value then it stores as 2/14/4366 B.C But if i create date/time field then the value is stored as 1/1/1970 Please let me know what needs to be done. Regards, Amey Bhosale On Thu, Sep 3, 2009 at 8:52 PM, LJ Longwing <lj.longw...@gmail.com> wrote: ** Amey, You aren't going to like this, but you need to use a Date field, because the Date/Time field cannot be used beyond 2038 as you discussed. This is based on a 32 bit integer limitation. You will need to convert your app to using Date only fields. _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of AMEY BHOSALE Sent: Thursday, September 03, 2009 9:15 AM To: arslist@ARSLIST.ORG Subject: Date Time Field Limitation Issue in Remedy restricted to Jan 2038 ** Hi All, We have an issue which was seen today that in Remedy there are two types of field : - 1. Date / Time Field 2. Date Field So in Date / Time Field it can accept date /time till Jan 2038 only and not beyond that. We have users who are using our Remedy application for Trade Related issues.So in case there are some fields like : - Trade Date Maturity Date So in case for a Trade = 123 you can select the max date for Maturity Date / Time Field till Jan 2038 and not beyond that but there are some trades which have maturity date that needs to be 2040 or beyond that which cannot be done in this case. Can anyone let me know how should i set value in Date / Time Field beyond Jan 2038 or another other solution for it ? Regards, Amey Bhosale _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"