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]] On Behalf Of Warren R. Baltimore II
Sent: Monday, October 28, 2013 9:33 AM
To: [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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
