topic Re: Date is wrong in attributes in ArcGIS Survey123 Questions

Date is wrong in attributes

CynthiaLieberman — Wed, 15 May 2019 16:55:32 GMT

We noticed that the Date field in the attributes is one day earlier than the actual submitted date. Is this fixable? Is there a work-around that allows me to have the actual date (I'm in Eastern Standard Time) rather than the "one day earlier date" in my attributes?

Re: Date is wrong in attributes

DavidForbuss1 — Wed, 15 May 2019 19:17:58 GMT

We were having a similar issue and figured out that it was because one of the dates was being written using UTC time. We're in Pacific Time so it's UTC minus 8 hours for us. I'm guessing you'd be UTC minus 5. Based on that you'd still be getting dates on the 15th so I'm not really sure what is going on in your case. It might be defaulting to the whatever timezone was set in the database when it was originally spun up.

Re: Date is wrong in attributes

Anonymous User — Wed, 15 May 2019 22:14:56 GMT

Thank you, David! We are still fiddling with it...

Re: Date is wrong in attributes

CPoynter — Wed, 15 May 2019 22:59:24 GMT

You can try doing a calculation on date to add / subtract the required number of hours to adjust your date. Otherwise this posting mentions an offset to adjust date/time.

Re: Date is wrong in attributes

JamesTedrick — Mon, 20 May 2019 22:51:06 GMT

Hi Cindy,

Just to check, the Date field you are highlighting is a 'Date' question? If so, that is stored as midnight in the submitting time zone - if someone submits this in a timezone west of you, it may appear as the previous day.