A B ...

First, Set DATEFIRST 6 --Since I wish to start counting records on saturday to Friday of every week.

SELECT COUNT(ClearedDate) AS 'Month',

...

Hello Genius people,

I rewrite the script and it's still not showing the correct display as I wish. Would you please tell me what wrong with my script? Here is my...

Select Count(ClearedDate) As 'Total Cleared'

from DEClearedDate

Where (Datepart(dw,ClearedDate)>=1) And (Datepart(dw,ClearedDate)<=6)

Here is the format of my table

dbo.DEClearearedDate

ClearedDate

10/4/2008

10/5/2008 ...