Survey 123 not exporting correct time to excel

Question

Hi there,

I've created a survey in Survey 123 and have selected DateTime as a field type and am having trouble getting the correct time to show up when I export the collected data to an excel file.  In survey 123 i'm seeing the correct time but when i export to excel it shows 5 hours off.  I have tried putting the pulldata function into survey 123 but perhaps i'm missing something here.  I've attached a few files of what my excel spreadsheet for my survey looks like as well as the exported output excel file.  All I want is the correct date and time for the data collected. I'm assuming theres something wrong with my formula or the way it "talks" to the DateTime field.

Any input or guidance would be much appreciated.

Thanks,

Levi

Survey123 excel file.png

data output exported from survey123.png

3.png

2.png

JessicaBowser · Answer

When adding the UTC offset to an existing survey will it correct data that is already in the feature layer when exporting or only new data moving forward?

NancyLarson · Answer

Winley, I am not sure what you are asking. I am not familiar with having this issue?

Nancy Larson, Financial & Operations Manager | Mississippi Valley Conservancy | 608.784.3606 Ext. 1

www.mississippivalleyconservancy.org<http://www.mississippivalleyconservancy.org/> | The Land. Our Future.

To Conserve native habitats and farmlands in the Driftless Area for the health and well-being of current and future generations.

image001.jpg

WinleyDurham · Answer

Nancy, did any of these work for you? Having the same issue, but mine is 8 hours off. Thanks.