AnsweredAssumed Answered

How can I insert local time in database from Survey123 form?

Question asked by kvernon93 on Feb 21, 2020
Latest reply on Feb 24, 2020 by j.moore-esristaff

I have a survey that asks for the dat and time a sample was collected and incubated. This survey is linked to a Feature Service in my ArcGIS server environment which references data in my company's locally hosted database, SQL Server.

Whilst creating a report for the data entered from the survey I discovered that the timestamp is set in UTC time, which is a 6 hour difference from my time.

I set this calculated field in the 123 Connect form, however this doesn't seem to work as nothing is inserted into that column in the database when submitting a survey:

How can I overcome this? My time zone is UTC -6

Outcomes