topic Date on Survey123 is different when generating a report... in ArcGIS Survey123 Questions

Date on Survey123 is different when generating a report...

deleted-user-obxnaKO3IpTF — Wed, 14 Mar 2018 07:31:05 GMT

Hello,

I am facing now a new issue and it's with the reports in Survey123.

So we have a field named "Reporting Date" and I have placed the field in my template for reports. but when i generate the report the date is one day less than the date its actually reported...?? is this because of timezone? mine is Kabul Afghanistan Time (AFT) is 4:30 hours ahead of Coordinated Universal Time

This is how it's shown on Survey123 web.

and after generating a report it's one day less....weird!

please let me know how to fix..

thanks

Re: Date on Survey123 is different when generating a report...

JamesTedrick — Wed, 14 Mar 2018 16:55:24 GMT

Hi Abdul,

This does sound like an issue with time zones. You can set the time offset from UTC to print the date using a utcOffset parameter with the date - see Print survey results—Survey123 for ArcGIS | ArcGIS

${timeField|utcOffset:"+01:00"}

Re: Date on Survey123 is different when generating a report...

deleted-user-obxnaKO3IpTF — Thu, 15 Mar 2018 07:06:00 GMT

Hi James,

Thanks for your reply. I am not able to use this on the date field i think...?

I keep having this error, get errors when preprocessing the template: ScopeParserError: Scope parser execution failed The scope parser for the tag rpt_dte |utcOffset:"+01:00" failed to execute ?

${rpt_dte |utcOffset:"+01:00"}

I think the offset tag is for time fields only?

Thanks again

Re: Date on Survey123 is different when generating a report...

JamesTedrick — Thu, 15 Mar 2018 16:56:09 GMT

Hi Abdul,

It does look like the syntax is correct. Could you try an alternative format (i.e., "+01" or "+0100")?

Re: Date on Survey123 is different when generating a report...

PabloGallego1 — Thu, 19 Jul 2018 12:23:49 GMT

Hi James and Abdul,

Have you solved the issue? I am having exactly the same problem in the UK ( UTC -1) and the proposed solution ( ${rpt_dte |utcOffset:"+01:00"} ) seems to not work. I entered the formula into the calculation field but it returns an error.

See above the resulting date which shows June 3 instead of June 4.

Any suggestions?

Re: Date on Survey123 is different when generating a report...

Anonymous User — Thu, 19 Jul 2018 23:05:32 GMT

Hi Pablo,

Please see the comment in the issue: https://community.esri.com/thread/217841-utcoffset-expression-in-report-not-working . Currently, we don’t support utcOffset in the report template syntax which is incorrectly documented and will be fixed shortly.

Also we will have a hotfix which addresses the date issue in the middle of the next week.

Phil.

Re: Date on Survey123 is different when generating a report...

ReneAubut — Fri, 09 Nov 2018 16:11:09 GMT

Hi, was it fixed? I get error message

Re: Date on Survey123 is different when generating a report...

JodyZhengLiu — Fri, 22 Nov 2019 07:16:34 GMT

Hi Abdul,

The syntax of utcOffset is available now on https://survey123beta.arcgis.com,along with other new beta features for the next release. We would love to have you have a test and share any feedback or issues you may encounter in the Survey123 Beta Website Feedback forum.

Thanks,

Jody Zheng Liu

Re: Date on Survey123 is different when generating a report...

JodyZhengLiu — Fri, 22 Nov 2019 07:16:54 GMT

Hi Pablo,

Thanks,

Jody Zheng Liu

Re: Date on Survey123 is different when generating a report...

JodyZhengLiu — Fri, 22 Nov 2019 07:17:05 GMT

Hi Rene,

Thanks,

Jody Zheng Liu