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))
