topic Date/Time values from Collector in ArcGIS Collector Questions https://community.esri.com/t5/arcgis-collector-questions/date-time-values-from-collector/m-p/553734#M9487 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp;</P><P></P><P>We have had a problem when syncing Collector and the data is not showing up in our database.&nbsp; I have managed to extract the data from the device and can view the data in a sql lite viewer.&nbsp; &nbsp; I have extracted all the required data except the date and times.&nbsp; They are showing in a sql lite viewer as e.g 2457800.55.</P><P></P><P>Does anybody know what time format this is/how to convert it?</P><P></P><P>I have 2 known records that show the correct time but cannot work out how to convert the rest.</P><P>e.g.</P><P>I know that:</P><P></P><P>2457800.549 = 16/02/2017 1:09:56 AM</P><P>2457800.55 = 16/02/2017 1:11:40 AM</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 15 Dec 2017 02:43:25 GMT Environment_SouthlandGIS_Servi 2017-12-15T02:43:25Z Date/Time values from Collector https://community.esri.com/t5/arcgis-collector-questions/date-time-values-from-collector/m-p/553734#M9487 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp;</P><P></P><P>We have had a problem when syncing Collector and the data is not showing up in our database.&nbsp; I have managed to extract the data from the device and can view the data in a sql lite viewer.&nbsp; &nbsp; I have extracted all the required data except the date and times.&nbsp; They are showing in a sql lite viewer as e.g 2457800.55.</P><P></P><P>Does anybody know what time format this is/how to convert it?</P><P></P><P>I have 2 known records that show the correct time but cannot work out how to convert the rest.</P><P>e.g.</P><P>I know that:</P><P></P><P>2457800.549 = 16/02/2017 1:09:56 AM</P><P>2457800.55 = 16/02/2017 1:11:40 AM</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 15 Dec 2017 02:43:25 GMT https://community.esri.com/t5/arcgis-collector-questions/date-time-values-from-collector/m-p/553734#M9487 Environment_SouthlandGIS_Servi 2017-12-15T02:43:25Z Re: Date/Time values from Collector https://community.esri.com/t5/arcgis-collector-questions/date-time-values-from-collector/m-p/553735#M9488 <HTML><HEAD></HEAD><BODY><P>It appears to be expressed in Julian Days.&nbsp;see for instance this online converter:</P><P><A class="link-titled" href="http://www.onlineconversion.com/julian_date.htm" title="http://www.onlineconversion.com/julian_date.htm">Online Conversion - Julian Date Converter</A>&nbsp;</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/390977_pastedImage_1.png" style="width: auto; height: auto;" /></P><P></P><P>... or you can use some python implementing existing modules like:&nbsp;<A class="link-titled" href="https://pypi.python.org/pypi/julian/0.14" title="https://pypi.python.org/pypi/julian/0.14">julian 0.14 : Python Package Index</A>&nbsp;</P></BODY></HTML> Fri, 15 Dec 2017 12:51:30 GMT https://community.esri.com/t5/arcgis-collector-questions/date-time-values-from-collector/m-p/553735#M9488 XanderBakker 2017-12-15T12:51:30Z Re: Date/Time values from Collector https://community.esri.com/t5/arcgis-collector-questions/date-time-values-from-collector/m-p/553736#M9489 <HTML><HEAD></HEAD><BODY><P>Perfect.&nbsp; Thank you very much!!!</P></BODY></HTML> Fri, 15 Dec 2017 20:12:50 GMT https://community.esri.com/t5/arcgis-collector-questions/date-time-values-from-collector/m-p/553736#M9489 Environment_SouthlandGIS_Servi 2017-12-15T20:12:50Z