I want get current selected month dropdown(september) this month get previous month data in Asp.net with C# or sql server
Below code I am using but result was not came
Sql Query:
select substring(DATENAME(MONTH, ProcessDate),1,3) as Month from Accounts_DailyAttendance where datename(MONTH,ProcessDate)='September'
The above query wise
i want result is October month data
Thanks
Khan Abrar AhmedPosted Dec 7, 2014, 5:33 AM
DECLARE @CurrentDate DATETIME =GETDATE();
SELECT DATENAME(MONTH,DATEADD(MONTH,-1,@CurrentDate))
select substring(DATENAME(MONTH, ProcessDate),1,3) as MONTH
from Accounts_DailyAttendance
where datename(MONTH,ProcessDate)=DATENAME(MONTH,DATEADD(MONTH,-1,@CurrentDate))