Splitting crime data into separate months

2616
5
Jump to solution
12-22-2015 08:49 PM
CaroleWacta
Occasional Contributor

Hello, I am trying to map crime in GISonline, though, it only accepts up to 1000 features,

So I decided to split my data[that I have made a shape file of] into months...

I opened the property and did

"Date" =  date '2015-01%' to only get January..

But it is not working.

1. Am I doing it wrong?

2. how do I prepare the data to use in GIS online.

I do have the same data in excel file.

I have attached my crime file

Thank you so much...

Christine

0 Kudos
1 Solution

Accepted Solutions
WesMiller
Regular Contributor III

Try using

"Date" >= date '2015-01-01 00:00:00'  AND  "Date" <= date '2015-01-31 00:00:00'

View solution in original post

5 Replies
DanPatterson_Retired
MVP Emeritus

perhaps your date format is different than that used by the online version.  In the U.S, day/month/year is more common than the international year/month/day

0 Kudos
NeilAyres
MVP Alum

I though that in the US they use month/day/year... Always confuses me

0 Kudos
DanPatterson_Retired
MVP Emeritus

oh yeah ... that is right there are 12 confusing dates per year instead of 0

0 Kudos
WesMiller
Regular Contributor III

Try using

"Date" >= date '2015-01-01 00:00:00'  AND  "Date" <= date '2015-01-31 00:00:00'

CaroleWacta
Occasional Contributor

Tank you Sooo much...

It works...

Christine

0 Kudos