return record count by quarter

jtyson · June 29th, 2004, 09:49 AM

Hi,

I have a simple table with a Submitted datetime column. I would like to return a COUNT of records, by quarter, to my web page. I use standard yearly quarters of Jan-Mar = Q1, Apr-Jun = Q2, Jul-Sep = Q3, Oct-Dec = Q4. Based on the current date GETDATE() and the date in the Submitted column of my table, how can I determine to COUNT of records in the current quarter?

Thanks you,

John

happygv · June 29th, 2004, 11:24 PM

You can use this.

Code:

SELECT count(*) FROM YOURTABLE WHERE datepart(q,Submitted)=datepart(q,getdate())

Cheers!

_________________________
- Vijay G
Strive for Perfection