Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select *from #ResultData WHERE YEAR(CONVERT(date, '01-' + Monthformat)) = YEAR(GETDATE()) - 1;
- --Getting current Year
- select *from #ResultData WHERE YEAR(CONVERT(DATE, '01-' + Monthformat)) = YEAR(GETDATE()) AND MONTH(CONVERT(DATE, '01-' + Monthformat)) <= MONTH(GETDATE());
- --Getting previous Year
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement