Re: getting sum of units sold in preceeding weeks

From: Nikhil (anonymous_at_discussions.microsoft.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 01:31:06 -0700

Dear Vishal..

thanks for the response...however i still do have a problem....when it calculates for the (say) 2nd preceeding week..it should not add the 1st preceeding week unitssold...

e.g : previous week is all dates between (current date) and (current date -7)
and 2nd previous week is all dates between (current date - 8) and (current date - 15)

could you plz once again help me out...

regards

Nikhil