topic Record the Date without the Time in ArcGIS Collector Questions https://community.esri.com/t5/arcgis-collector-questions/record-the-date-without-the-time/m-p/539855#M9244 <HTML><HEAD></HEAD><BODY><P>When recording the Date, there is a default for time. This is creating havoc when I try to create a Pivot Table from a converted excel file. I need to be able to sort by date and the added time is messing everything up? is there a way to only collect the Date and not have the Time option? or in excel eliminate the Time? every Format Cell option keeps the time in the background?</P></BODY></HTML> Mon, 07 Jan 2019 18:21:30 GMT Anonymous User 2019-01-07T18:21:30Z Record the Date without the Time https://community.esri.com/t5/arcgis-collector-questions/record-the-date-without-the-time/m-p/539855#M9244 <HTML><HEAD></HEAD><BODY><P>When recording the Date, there is a default for time. This is creating havoc when I try to create a Pivot Table from a converted excel file. I need to be able to sort by date and the added time is messing everything up? is there a way to only collect the Date and not have the Time option? or in excel eliminate the Time? every Format Cell option keeps the time in the background?</P></BODY></HTML> Mon, 07 Jan 2019 18:21:30 GMT https://community.esri.com/t5/arcgis-collector-questions/record-the-date-without-the-time/m-p/539855#M9244 Anonymous User 2019-01-07T18:21:30Z