Hey,
I have a sub query that gets the previous data. I want to re write it to get the previous data by 4 months. How would i go about doing that?
How can i set it up to change the last month, to 4 months ago.. IE>Code:(SELECT MAX(T2.MonthlyDate) FROM tblDates AS T2 WHERE T2.ProductID=tblDates.[ProductID] AND T2.MonthlyDate < tblDates.MonthlyDate) As PriorDate
MonthlyDate....PriorDate
31/01/2013
28/02/2013
31/03/2013
30/04/2013
31/05/2013.....31/01/2013
And so on....
Thanks.