| 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 years | Tompkins Neil | 29 Apr |
| • Re: Obtain week number between years | Johan De Meersman | 29 Apr |
| • Re: Obtain week number between years | Baron Schwartz | 29 Apr |
| • RE: Obtain week number between years | Steven Staples | 29 Apr |