Encounters per Year

Finding the number of annual encounters involves running the following query against the Works DB in SQL:

select count( * ) from encounter where DATEDIFF(day,encounter.dttm, GETDATE()) < 365