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.
