MSSQL+Date

[stevelibby]

Hello
I am doing a query but am stuck.
I want to customers but group them by date. Query as follows:
SELECT Count(Customers.CustomersID) AS CountOfCustomersID, Customers.Date
FROM Customers
GROUP BY Customers.Date;
The date field in mysql is a date(), My question is how can i get them to show by month? they currently show by day.

[aspdaddy]

SQL has a month function that returns a number

SELECT Count(Customers.CustomersID) AS CountOfCustomersID, Month(Customers.Date)
FROM Customers
GROUP BY Month(Customers.Date)

[syber]

If you want to group by calendar month, I would suggest:

SELECT Count(Customers.CustomersID) AS CountOfCustomersID, Year(Customers.Date), Month(Customers.Date)
FROM Customers
GROUP BY Year(Customers.Date), Month(Customers.Date)
ORDER BY Year(Customers.Date), Month(Customers.Date)

Art

[stevelibby]

Hi
I have just tried and it doesnt work? what am i doing wrong?

[mattglet]

What are you getting for an error?

[Easy_Coder]

Have you tried the DatePart function

SELECT DATEPART(month, GETDATE()) AS 'Month Number'

[stevelibby]

i have run both code in frontpage wizard, which is how i do all queries, but once uploaded doesnt give anything anther than unable to show results.

[aspdaddy]

In the title you put MSSQL & in the message MySQL-which database are you using?