How to Query Current Month Inspection Data from a File Geodatabase in ArcMap

You can display the results of an inspection for specific dates (e.g. current month) without having to update the query each month by using the following script in the Definition Query:

*Note: Field type must be ‘Date’

EXTRACT(MONTH FROM “YourDateField“) = EXTRACT(MONTH FROM CURRENT_DATE)