topic Re: Splitting crime data into separate months in New to GIS Questions https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213392#M540 <HTML><HEAD></HEAD><BODY><P>oh yeah ... that is right there are 12 confusing dates per year instead of 0</P></BODY></HTML> Wed, 23 Dec 2015 09:39:42 GMT DanPatterson_Retired 2015-12-23T09:39:42Z Splitting crime data into separate months https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213389#M537 <HTML><HEAD></HEAD><BODY><P>Hello, I am trying to map crime in GISonline, though, it only accepts up to 1000 features, </P><P>So I decided to split my data[that I have made a shape file of] into months...</P><P>I opened the property and did</P><P>"Date" =&nbsp; date '2015-01%' to only get January..</P><P>But it is not working.</P><P>1. Am I doing it wrong?</P><P>2. how do I prepare the data to use in GIS online.</P><P>I do have the same data in excel file.</P><P></P><P>I have attached my crime file</P><P>Thank you so much...</P><P>Christine</P></BODY></HTML> Wed, 23 Dec 2015 04:49:40 GMT https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213389#M537 CaroleWacta 2015-12-23T04:49:40Z Re: Splitting crime data into separate months https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213390#M538 <HTML><HEAD></HEAD><BODY><P>perhaps your date format is different than that used by the online version.&nbsp; In the U.S, day/month/year is more common than the international year/month/day</P></BODY></HTML> Wed, 23 Dec 2015 05:11:23 GMT https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213390#M538 DanPatterson_Retired 2015-12-23T05:11:23Z Re: Splitting crime data into separate months https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213391#M539 <HTML><HEAD></HEAD><BODY><P>I though that in the US they use month/day/year... Always confuses me<IMG src="https://community.esri.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Wed, 23 Dec 2015 06:40:20 GMT https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213391#M539 NeilAyres 2015-12-23T06:40:20Z Re: Splitting crime data into separate months https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213392#M540 <HTML><HEAD></HEAD><BODY><P>oh yeah ... that is right there are 12 confusing dates per year instead of 0</P></BODY></HTML> Wed, 23 Dec 2015 09:39:42 GMT https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213392#M540 DanPatterson_Retired 2015-12-23T09:39:42Z Re: Splitting crime data into separate months https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213393#M541 <HTML><HEAD></HEAD><BODY><P>Try using</P><P>"Date" &gt;= date '2015-01-01 00:00:00'&nbsp; AND&nbsp; "Date" &lt;= date '2015-01-31 00:00:00'</P></BODY></HTML> Wed, 23 Dec 2015 13:26:07 GMT https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213393#M541 WesMiller 2015-12-23T13:26:07Z Re: Splitting crime data into separate months https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213394#M542 <HTML><HEAD></HEAD><BODY><P>Tank you Sooo much...</P><P>It works...</P><P>Christine</P></BODY></HTML> Wed, 23 Dec 2015 14:52:14 GMT https://community.esri.com/t5/new-to-gis-questions/splitting-crime-data-into-separate-months/m-p/213394#M542 CaroleWacta 2015-12-23T14:52:14Z