The following clause will return the total number of newly hired employees of a company from Aug, 2005 to April, 2006.

select  count(*) as total   from employees
                  where
 (([hiredate]>CAST('2005-Aug' AS datetime) and ([hiredate]<CAST('2006-Apr' AS datetime))