<div>
of course ..........., sorry for the silly question<br />
<br />
JT
</div>


of course ..........., sorry for the silly question

JT

<div>
no problem.<br />
<br />
I can't tell you how many times I have missed the obvious answer thinking it must be more complex.
</div>


no problem.

I can't tell you how many times I have missed the obvious answer thinking it must be more complex.

<div>
<div class="content wysiwyg-content">
I want to work out weekly stats on specific records for the year, what i want to achieve is the following: &nbsp;-<br />
<br />
I want to count a new week starting on a monday and ending on sunday<br />
<br />
For each year start week 1 on the first monday of january<br />
<br />
How do i go about setting this up ?<br />
<br />
I have the following query but this counts from Sunday first<br />
<br />
SELECT COUNT(*)<br />
FROM Table<br />
WHERE DATEPART(week, GETDATE()) = DATEPART(week, dateadded)<br />
<br />
<br />
So the output would be for today 12/04/05: - <br />
<br />
WEEK 15<br />
<br />
Record count 3 etc..<br />
<br />
Cheers<br />
<br />
JT
</div>
</div>


I want to work out weekly stats on specific records for the year, what i want to achieve is the following:  -

I want to count a new week starting on a monday and ending on sunday

For each year start week 1 on the first monday of january

How do i go about setting this up ?

I have the following query but this counts from Sunday first

SELECT COUNT(*)
FROM Table
WHERE DATEPART(week, GETDATE()) = DATEPART(week, dateadded)


So the output would be for today 12/04/05: - 

WEEK 15

Record count 3 etc..

Cheers

JT

Compare Dates Weekly Starting From Monday Instead Of Sunday ?

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.