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
Solved! Go to Solution.
Try using
"Date" >= date '2015-01-01 00:00:00' AND "Date" <= date '2015-01-31 00:00:00'
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
I though that in the US they use month/day/year... Always confuses me
oh yeah ... that is right there are 12 confusing dates per year instead of 0
Try using
"Date" >= date '2015-01-01 00:00:00' AND "Date" <= date '2015-01-31 00:00:00'
Tank you Sooo much...
It works...
Christine