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 < frederick.w.gro...@xo.com> 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: > arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II > Sent: Monday, October 28, 2013 9:33 AM > To: arslist@ARSLIST.ORG > 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 > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > -- Warren R. Baltimore II Remedy Developer 410-533-5367 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
