Hi,
I have a date field in Form. The selected date i need to pass it to integration service which is a datetime field. For my inputted date to pass i need to convert todatetime to pass into integration. The issue we are seeing is below conversion is appending the timezone to the datetimefield which is not needed.
ActualResult:
todatetime(ri!BGDate)
7/20/2023 12:00 AM GMT+00:00(Date and Time with Timezone)
ExpectedResult:
7/20/2023 12:00 AM (Date and Time)
Kindly suggest.
Discussion posts and replies are publicly visible
When i pass as you just wrote into external system input got the error as below. Its expecting Date Time instead of a text.Internally the Rest endpoint of the service will make a call to Soap Endpoint of .Net version which expects a datatype.
I am taking the risk to repeat myself. There is no date/datetime datatype in JSON!
Any date/datetime is transformed into a string. That service then needs to be able to decode that specific format. The internet recommends to use the format defined in ISO 8601.
You will have to discuss with the team developing that service, what format they expect. And you know how to achieve that in Appian.
I understood now. I checked the external system input format and i formatted using text field now its working as expected.
text(now(), "yyyy-mm-dd") & "T07:17:16.652"
Thanks Guys!!!