Skip to Content
0
Former Member
Aug 04, 2010 at 02:27 PM

Sum sales query last 6 months

63 Views

Hi people......

Using docdate and sum(quantity) how can i sum the last 6 months from today.??

select itemcode, sum(quantity) FROM oinv, inv1, oitm, oitb....... WHERE getdate() ?????

I hope explain correctly....