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
The gmt() function might help you.
I returns 7/20/2023 12:00 AM GMT+00:00(Date and Time) expected is 7/20/2023 12:00 AM(Date and Time)
This is just how it is displayed. But when you need more control on the format, you can also use the text() function.
May be i am asking question in an incorrect way. I have a date which needs to be converted into just date and time without any timezone appended to it.
Actual
7/20/2023 12:00 AM GMT+00:00(Date and Time)
Expected
The issue here is, that there is the value and its textual representation on the screen. And these are two different things.
The value itself is defined by the data type, and the visual by a formatting function. By default Appian uses some standard Java functions to do that.
If that is not what you want, change the type and/or the formatting.
I am not just referring to textual representation which we can modify using text() function.However, I need actual datetime returned by the todatetime() function.It should not contain timezone appeneded to it. When we bring data to appian to display we may need to convert to appian equivalent which is appending timezone to our datetime fields , we are ok if it can be reconverted back to exact datetime without appending timezone.
Looking forward for a response regarding date and time without timezone conversion from date and time with timezone.
Is there any actual issue with this? In 13+ years with Appian I never had any problem with this. Where did you get your doubts?