I am experiencing an issue with dates while consuming a web service. The web ser

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

Parents Reply Children
No Data