last tow month data

Hi Thulasiram pakala,

 

try this

 

SELECT empname from empTable where joiningdate between DATEADD(month,-1,01-01-2018) and '01-01-2018' 

 

in place of this date 01-01-2018, pass your date variable

string inputText = "2019-01-09";//input date is jan 9th you selected OK now you want last 60 days it means 2 months back

DateTime dt = DateTime.Parse(inputText);

DateTime previousdate = dt.AddMonths(-2);

string print_previousdate = previousdate.ToString("dd-MMM-yyyy");

// then go for sql query,here i given a example (you have to check with your tbl coulmn data type and all ok)

// select * from where date>=print_previousdate and date<=dt;