Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
7 subscribers
Views
963 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I am experiencing an issue with dates while consuming a web service. The web ser
giridharn
over 9 years ago
I am experiencing an issue with dates while consuming a web service. The web service that I am calling expects two dates and returns the number of days between them. I am passing dates (with no time) to the web service but for some reason, when it hits the web service it has time component to it which gives inaccurate results. For instance if I pass the following dates
9/29/2014 and 12/4/2014, I am expecting a return value of 66 but I am getting back 65 because when it hits the web service, it has 9/29/2014 8:00 PM EDT and 12/4/2014 7:00 PM EST
Below is the call I am making
=webservicequery(
a!wsConfig(wsdlUrl: cons!XXX_WSDL, service: "{
http://xxx.com}Service",
port: "tomoRateSoap11", operation: "{
http://xxx.com}Validate"
),
{
ValidateRequest: {
opr:{
startDate:ri!startDate,
endDate:ri!endDate
}
}
}
).returnValue.ValidateResponse
Any thoughts on how to resolve this? I tried several things like passing...
OriginalPostID-124535
OriginalPostID-124535
Discussion posts and replies are publicly visible
0
giridharn
over 9 years ago
... 12:00 AM as the time component but nothing I tried is working.
It is date fields in Appian and also is date in the web service schema NOT datetime
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel