Skip to main content
sameeru0003
sameeru0003
Known Participant
Jul 20, 2023 8:05 AM UTC
Question

Date and time without timezone

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:

todatetime(ri!BGDate)

7/20/2023 12:00 AM (Date and Time)

Kindly suggest.

13 replies

stefanhelzle0001
stefanhelzle0001
Brainy
Jul 20, 2023 8:24 AM UTC

The gmt() function might help you.

sameeru0003
sameeru0003Author
Known Participant
Jul 20, 2023 8:51 AM UTC

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)

 

stefanhelzle0001
stefanhelzle0001
Brainy
Jul 20, 2023 8:58 AM UTC

This is just how it is displayed. But when you need more control on the format, you can also use the text() function.

Terms & ConditionsAccessibility statement