Date Wise Filter in sql server?

how to Date Wise Filter in sql server?

Now i am ItemID Wise data can be Properly show. but my need IssueDate Wise data show.

ItemID Wise Query is - WITH Last3Month AS (SELECT DISTINCT TOP 3 MONTH(IssueDate) AS Mth FROM Issue WHERE ItemId = 452 ORDER BY Mth DESC) SELECT CONVERT(CHAR, DATENAME(MONTH, IssueDate)) AS MonthName, ItemId,COUNT(CONVERT(varchar, IssueDate, 6)) AS WorkingDays FROM dbo.Issue AS Issue INNER JOIN Last3Month ON MONTH(Issue.IssueDate) = Last3Month.Mth GROUP BY CONVERT(CHAR, DATENAME(MONTH, IssueDate)), ItemId, Last3Month.Mth HAVING (ItemId = 452) ORDER BY Last3Month.Mth

ItemID Wise Result is

IssueDate Wise Query is - WITH Last3Month AS (SELECT DISTINCT TOP (3) MONTH(IssueDate) AS Mth FROM dbo.Issue AS Issue_1 WHERE(IssueDate BETWEEN '01-01-14' AND '01-01-17') ORDER BY Mth DESC) SELECT CONVERT(CHAR, DATENAME(MONTH, Issue.IssueDate)) AS MonthName, Issue.ItemId, COUNT(CONVERT(varchar, Issue.IssueDate, 6)) AS WorkingDays, SUM(Issue.IssueQuantity) AS IssueQty FROM dbo.Issue AS Issue INNER JOIN Last3Month AS Last3Month_1 ON MONTH(Issue.IssueDate) = Last3Month_1.Mth WHERE (Issue.IssueDate BETWEEN '01-01-14' AND '01-01-17') GROUP BY CONVERT(CHAR, DATENAME(MONTH, Issue.IssueDate)), Issue.ItemId, Last3Month_1.Mth HAVING (Issue.ItemId = 452) ORDER BY Last3Month_1.Mth

IssueDate Wise Result is

plz help me.