Skip to main content
sameeru0003
sameeru0003
July 20, 2023
Question

Date and time without timezone

  • July 20, 2023
  • 13 replies
  • 0 views

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
July 20, 2023

The gmt() function might help you.

sameeru0003
sameeru0003Author
July 20, 2023

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
July 20, 2023

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