nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 Report dates off by one

GingerHarrington

I am using Survey123 for inspections. They inspections are completed monthly and I have created the report as a Word document to print the inspection. I have been using this data and information all year. I have in my data 6 dates. The date is correct in Survey123; however when I generate the report, the date shows up as 1 day earlier for October but not November. (Example data entered as October 9 but shows up as October 8.) This error did not occur last month. Any ideas?

Find more posts tagged with

Accepted answers

All comments

JamesTedrick

Hi Ginger,

That could be a solution; there are a couple of others.

For already collected data, you could either re-calculate the answer with +1 hour or create an Arcade Expression to do the same in a 'calculated' column.

To ensure new data is collected correctly, for datetime questions you could change the today() function to the following calculation:

decimal-date-time(today()) + (1 div 24)

This won't work for date questions, however

GingerHarrington

Thank for the insight.

I just want to clarify.

The only way to correct this situation is to create another field which is a calculated field and add an hour to the previous date field. Then change my report to show the new calculated field rather than the date entered.

Is that correct?

JamesTedrick

Hi all,

As discussed, this is related to the change from Daylight to Standard time. Survey123 stores dates as occuring in midnight in the timezone the device occurs. Times are stored in ArcGIS Online as UTC times; browsers automatically convert the time to the UTC offset. Given the change to Standard time, the UTC offset of the browser shifted by one hour, causing the local midnight to become 11:00pm the previous day when viewed now. Conversely, dates recorded in Standard time and viewed while Daylight Savings while display 1:00 am instead of midnight.

EricCollins

It could also be a UTC/local offset (time zone) issue. We're in -6/-7 Mountain time and have seen dates out by a day depending how they are stored.

TylerGraham2

It does appear to be a DST problem and how AGOL/report generator handles it. I ran the generate report on a dataset of mine with a XLSForm Date field and it bumped me back to the previous day. I played around with a new form with the date/time fields. I think if you adjust your time a head 1 hour (+60*60*1000) in the date field it will fix your error since it will set your date time to 1am instead of 12am, preventing it from rolling back a day. .

Field defined as Date in XLSForm.

XLSForm date field is still date/time in the feature service.

Generate Report bumps it back to the previous day. Sample of testing the date and time field

GingerHarrington

Mine is not hidden.

KassandraRodriguez

I saw my days were off by one day as well, this is something recent. The one having issues is hidden but the other date I have isn't and there are no problems with it. The hidden one also has this calculation pictured below. Maybe it has to do with it being hidden?

GingerHarrington

This is just a date field. Does this have something to do with Daylight Savings?

TylerGraham2

Is it just a Date field or a Date/Time field? AGO feature services store time differently than locally stored data. If you download data from AGO you will see a time shift which can affect the date you're seeing. Here in Washington State all my date/time data is advanced 8 hours when I download data, so if I have data that is collected later in the day (after 4pm), it shows the data as being collected the next day.

GingerHarrington

My reports generated on November 2, 2018 are correct. My reports generated on November 5 show the problem.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.