List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:April 29 2010 12:30pm
Subject:Re: Obtain week number between years
View as plain text  
group by week(yourdate) ?


On Thu, Apr 29, 2010 at 2:12 PM, Tompkins Neil <neil.tompkins@stripped
> wrote:

> 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
>



-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

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