Hi,
try this
select
substring(DATENAME(MONTH, ProcessDate),1,3) as Month
from
Accounts_DailyAttendance
where
Month(ProcessDate)=DateAdd(mm,1,convert(date,'1/'+ cast(DATEPART(MM,'September', year(getdate())) as char(2))+'/'+ cast(year(getdate()) as char(4)),103))