Emp_Id Month Year Name Created Date Type 00FBG 2 2014 prakasan 2014-01-12 10:21:54.730 R
select * from YourTable where Time_Open > dateadd(month, datediff(month, 0, GETDATE()) - 4, 0) and Time_Open < dateadd(month, datediff(month, 0, GETDATE()) - 1, 0)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)