topic Re: utcOffset Expression in report not working in ArcGIS Survey123 Questions

utcOffset Expression in report not working

KyleLindsay — Thu, 12 Jul 2018 22:09:33 GMT

I am trying to create a report with the utcOffset expression. I have tried ${time|utcOffset:"+01:00"}, ${time|utcOffset:"+0100"} and ${time|utcOffset:"+01"}. It seems to hang up while creating the report and the word document never opens up. The screenshot below is from the reporting/recent task tab.

If I remove the utcOffset and use ${datetime|format:"DD/MM HH:mm"} the report will be created.

Has anyone else had an issue with the utcOffset?

Re: utcOffset Expression in report not working

Anonymous User — Wed, 18 Jul 2018 06:17:40 GMT

Zhifang Wang‌ Can you please look into this issue?

Re: utcOffset Expression in report not working

ZhifangWang — Thu, 19 Jul 2018 11:40:29 GMT

Hi Kyle,

Currently, "utcOffset" is not supported in the report template syntax (we had an issue in the doc) but only supported as a parameter from API perspective. If you generate the report from the Survey123 website, we will pass the UTC offset of the browser automatically.

Would you mind sharing your use case of the “utcOffset" in the report template?

Re: utcOffset Expression in report not working

danbecker — Fri, 27 Jul 2018 14:35:45 GMT

Same here, utcOffset isn't working. We have ArcGIS enterprise, survey was created/published using survey123 Connect.

Trying to set utcOffset on a dateTime question so the output reports don't print UTC time, which is confusing to field crews reviewing the recently submitted data because it causes the date to sometimes be +1 day since PST is UTC-8.