Definition Query help? What query expression would I use for subsetting data to Burglaries occurring in December 2016?

Question

I put this expression into the Definition Query, but it says that the SQL statement is invalid: "Type" = 'BURGLARY' AND "Date" BETWEEN date '2016-12-01 00:00:00' AND date '2016-12-31 00:00:00'

What could be incorrect with this query expression?

Thanks!

__17 · Answer

Nevermind, I checked. I did it correctly. I checked the attribute table. Thanks!

__17 · Answer

Okay thanks. It finally worked! I edited the query expression. I changed it to:

"Type" = 'BURGLARY' AND "Date" >= date '2016-12-01 00:00:00' AND "Date" <= date '2016-12-31 00:00:00'

However, I still get confused between the 'AND' and 'OR' operators. I hope I am using the correct operator for finding the burglaries occurring in December 2016.

DanPatterson_Retired · Answer

Des...Tips...

* do the burglary query first... if it works
* do the date query second * If the date query doesn't work with between, try greater than your first date, that will check the date portion

* if they both work, then put the subqueries in round brackets with the 'and' between

Sorry, but no date data to check with, but hopefully breaking it down will isolate your problem