AnsweredAssumed Answered

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

Question asked by dlgree12 on Jan 27, 2018
Latest reply on Jan 27, 2018 by dlgree12

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!

Outcomes