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
8 replies
Subscribers
6 subscribers
Views
3029 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I am calling a web service from the Appian using the web service smart service.
vineeta6579
over 10 years ago
I am calling a web service from the Appian using the web service smart service. The service returns the date time field in response. When i am capturing the result of service in Appian its going one day forward of what date returned by the service.
I have Validated the result using SOAP UI, In SOAP UI its returns correct date only!
OriginalPostID-141216
OriginalPostID-141216
Discussion posts and replies are publicly visible
0
abhi.jana
Appian Employee
over 10 years ago
Where is the WSDL hosted? Does the web service host timezone match that of your Appian server?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 10 years ago
Service is hosted in EST timezone. Appian is cloud instance & EST time Zone is selected under internationalization settings.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Wrap it in the gmt function. Example
gmt(pv!DATE_RETRIEVED_GOES_HERE,usertimezone())
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
or simply: gmt(pv!DATE_RETRIEVED_GOES_HERE)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 10 years ago
Actually We are pulling & pushing data by services.The services and Database are hosted in EST Timezone.
Since WCF services does not support Data data type we are getting date time data type in the Request/ Response interfaces, but in the UI we using date component to display it.
In out project only data is significant part & times doesn't. We are showing only date we are showing/ updating on UI.
Do I need to use gmt function when i am pulling &pushing data ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Since dates are expected to be in GMT for Appian to transform them to the end user's timezone then yes, I suggest you test this:
For reading: gmt(pv!DATE_RETRIEVED_GOES_HERE,usertimezone())
For inserting: local(pv!DATE_RETRIEVED_GOES_HERE,usertimezone())
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
raghunandanj3904
Certified Senior Developer
over 10 years ago
Hi Eduardo, is there any way which we can avoid this timezone conversion when we get the data from the Services???
Its happening that, when we get the data itself, in d response the data coming is a converted one. can t we stop this and get the same datetime as returned by the service?? withouhg using any timezone functions?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Per the documentation Appian stores all dates in GMT to be able to display them in the end user's preferred timezone, therefore you need to do the necessary conversion to make sure Appian stores them in GMT given they come in a different time zone.
This is not needed when the date-time is provided within Appian because Appian is able to transform it and store it GMT.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel