List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:April 29 2010 12:12pm
Subject:Obtain week number between years
View as plain text  
Hi

We need to produce a query to return the total number of user visits between
two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29.
My question is how can I compute the totals for each week within a query ?
for example

2009-04-29 to 2009-05-06   100 visits
2009-05-07 to 2009-05-14   250 visits etc

Cheers
Neil

Thread
Obtain week number between yearsTompkins Neil29 Apr
  • Re: Obtain week number between yearsJohan De Meersman29 Apr
  • Re: Obtain week number between yearsBaron Schwartz29 Apr
    • RE: Obtain week number between yearsSteven Staples29 Apr