You are evaluating the two dates at the end using the same > evaluator. One would have to be > and one would have to be <.

that was a typo on my part. but even with that fixed it doenst fix the issue. It  From the image below you can see that even when I try just one of the  dates the first one is from 20200626, which is more than 3 months ago. 

SELECT ITEMNUM, LOCATION, QTYAVAIL, STOCKDATE, ASSETCOST
FROM dbo.ICXLOT
WHERE (QTYAVAIL > 0) AND (STOCKDATE >= DATEPART(MONTH, DATEADD(MONTH, - 3, GETDATE())))

that was a typo on my part. but even with that fixed it doenst fix the issue. It  From the image below you can see that even when I try just one of the  dates the first one is from 20200626, which is more than 3 months ago. 

SELECT ITEMNUM, LOCATION, QTYAVAIL, STOCKDATE, ASSETCOST
FROM dbo.ICXLOT
WHERE (QTYAVAIL > 0) AND (STOCKDATE >= DATEPART(MONTH, DATEADD(MONTH, - 3, GETDATE())))

Sage YYYYMMDD dates need to be converted to real dates, something like this:  

CONVERT(varchar, CONVERT(datetime, CONVERT(varchar, STOCKDATE)), 101)

Hmm Ok, I tried putting that into SQL but it isnt taking it. Ill try to keep playing with it and seeing if I can find out how to make that work. 

Ok, I got it to convert to MM/DD/YYY, but now I feel like I need to filter on the converted column and not the original, when I try the original filter criteria (below) it gives me an error. 

WHERE        (QTYAVAIL > 0) AND (CONVERT(varchar, CONVERT(datetime, CONVERT(varchar, STOCKDATE)), 101) >= DATEPART(MONTH, DATEADD(MONTH, - 3, GETDATE())))