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!
Des...Tips...
Sorry, but no date data to check with, but hopefully breaking it down will isolate your problem
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.
Nevermind, I checked. I did it correctly. I checked the attribute table. Thanks!