topic Re: collector csv wrong dates and times in ArcGIS Collector Questions https://community.esri.com/t5/arcgis-collector-questions/collector-csv-wrong-dates-and-times/m-p/319639#M5507 <HTML><HEAD></HEAD><BODY><P>AGOL uses UTC time by default.&nbsp; Collector will convert the date/time using the computer or phone's date settings. But to correct the date and time in the downloaded data, you will need to add/subtract your time&nbsp;offset from UTC.&nbsp; Search AGOL or ArcMap help documentation for "geodatabase time".</P><P></P><P>You also indicated that the field name is "DATE".&nbsp; Field names should not use SQL reserved words.&nbsp; If you want it to show up in Collector as "DATE", you can use the description/alias for this purpose.</P></BODY></HTML> Wed, 29 Mar 2017 00:31:41 GMT RandyBurton 2017-03-29T00:31:41Z collector csv wrong dates and times https://community.esri.com/t5/arcgis-collector-questions/collector-csv-wrong-dates-and-times/m-p/319638#M5506 <HTML><HEAD></HEAD><BODY><P>created a feature service. Used Collector to collect point data in the field. &nbsp;Have a DATE field and Collector places a time by default. &nbsp;Done collecting field data. &nbsp;Go to Arc Online, download the data as a CSV file and DATE field sometimes has incorrect date, but mostly off on the time collected by a couple hours. &nbsp;Field name is DATE in File geodb. Any clues? Answers? &nbsp;Much appreciated</P></BODY></HTML> Tue, 28 Mar 2017 18:45:32 GMT https://community.esri.com/t5/arcgis-collector-questions/collector-csv-wrong-dates-and-times/m-p/319638#M5506 deleted-user-8zpXkQfV8bQC 2017-03-28T18:45:32Z Re: collector csv wrong dates and times https://community.esri.com/t5/arcgis-collector-questions/collector-csv-wrong-dates-and-times/m-p/319639#M5507 <HTML><HEAD></HEAD><BODY><P>AGOL uses UTC time by default.&nbsp; Collector will convert the date/time using the computer or phone's date settings. But to correct the date and time in the downloaded data, you will need to add/subtract your time&nbsp;offset from UTC.&nbsp; Search AGOL or ArcMap help documentation for "geodatabase time".</P><P></P><P>You also indicated that the field name is "DATE".&nbsp; Field names should not use SQL reserved words.&nbsp; If you want it to show up in Collector as "DATE", you can use the description/alias for this purpose.</P></BODY></HTML> Wed, 29 Mar 2017 00:31:41 GMT https://community.esri.com/t5/arcgis-collector-questions/collector-csv-wrong-dates-and-times/m-p/319639#M5507 RandyBurton 2017-03-29T00:31:41Z