Survey123 Time Zone

256
0
03-01-2023 06:45 PM
Katelyn1
New Contributor II

Hi!

We have created a simple Survey123 form to collect 4 times & a unique identifier. All of the data is collected in UTC. 

I am in the AST time zone. I've tried using a hidden field with a calculation to get to the correct time, but it subtracts 24 hours (date-time(decimal-date-time(${Departure}) - 0.1666666666666667)). I've tried using pulldata(@property, 'utcOffset') and that sent my date back to 1969, and it has the wrong time as well.

Looking for some suggestions on how to perform this calculation using survey 123 connect. 

 

0 Kudos
0 Replies