Remedy understands all of the XML Date Time formats so there is no setting to change it.
I know there was a bug on XML processing that was fixed with 7.6.04 SP3 so if you are consuming a Remedy web service from a 7.6.04 server < SP3 that will correct the issue. Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Warren R. Baltimore II Sent: Monday, October 28, 2013 10:10 AM To: [email protected] Subject: Re: Dates and Web Services ** Fred, Thank you so much! I knew I was making this to difficult! Any idea where that setting might be? He's using a straight old Remedy Web Service to create what I am consuming. Otherwise I'll just convert it myself. Thanks for your help.... I really appreciate it! On Mon, Oct 28, 2013 at 10:56 AM, Grooms, Frederick W wrote: When you map an ARS Date/Time field in a filter consume web service call the web service plugin will automatically convert to a valid XML DateTime fiormat "yyyy-mm-ddThh:mm:ss-oh:om". It sounds like the web service you are consuming is not accepting the time zone offset (Which is part of the XML Date Time standards) and want's it hardcoded into the Z (Zulu/GMT) format. What you will have to do is to create it yourself as a string In pure ARS it would be something like YEAR($field$) + "-" + LPAD(MONTH($field$),2,"0") + "-" LPAD(DAY($field$),2,"0") + "T" + LPAD(HOUR($field$),2,"0") + ":" + LPAD(MINUTE($field$),2,"0") + ":" + LPAD(SECOND($field$),2,"0") + "Z" Making sure $field$ is a Date/Time field that is already adjusted for GMT Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Warren R. Baltimore II Sent: Monday, October 28, 2013 9:33 AM To: [email protected]<mailto:[email protected]> Subject: Dates and Web Services ** Good Morning/Afternoon/Evening fellow listers! It may be due to the heavy doses of cold medication that I have been taking over the last week, or just ignorance (or a combination of the two) but I am somewhat befuddled by dates and Web Services. I am trying to consume a WS from another ARS system. When we try to share dates, I am getting an error back "ERROR (8957): The date format is invalid". After some investigation, I found that I have to convert the timestamp from what my server is using to one in the format "yyyy-mm-ddThh:mm:ssZ" I know I'm making this way more complicated then it need be. But I've failed on all attempts. Could somebody point me in the correct direction to convert this? A snippet of code perhaps? Or maybe some nice hot Matzo Ball Soup to get my mind set straight? I'm on ARS 7.6.04 in a Windows environment and Sudafed for my cold.... :-) Thanks in Advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367<tel:410-533-5367> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org/> "Where the Answers Are, and have been for 20 years" -- Warren R. Baltimore II Remedy Developer 410-533-5367 _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
