mvc2011

Survey 123 not exporting correct time to excel

Discussion created by mvc2011 on Oct 15, 2018
Latest reply on Oct 15, 2018 by JTedrick-esristaff

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

Outcomes