Quarter

[mjd3000]

Is there a keyword that you can use in SQL Reporting Services that allows you to write queries based upon the quarter of the year that a particular date field is in?

 

[jymm]

I use datepart(Quarter, <datefield>) in the sql

so

select datepart(Quarter, getdate()), getdate()

should get you the quarter number of today's date...

make sense?

 

[mjd3000]

Thanks....how would I get Year, Month, Week and Day? Would it be the same as above but with the 'Year', 'Month', 'Week' and 'Day' replacing 'Quarter'?

Does this give me the actual Month and Day names, rather than the numbers?

 

[jymm]

cool thing about Google is that you can find this stuff pretty quickly.

http://msdn.microsoft.com/en-us/library/aa262714.aspx

I have been known to translate things in the sql. seems like I had a fancier way some place, but this should get you a start

SELECT DATEPART(WeekDay, getdate()) AS WeekDayPart, 
   DayOfTheWeek =
      CASE 
        WHEN DATEPART(WeekDay, getdate()) = 1 THEN 'Sunday'
        WHEN DATEPART(WeekDay, getdate()) = 2 THEN 'Monday'
        WHEN DATEPART(WeekDay, getdate()) = 3 THEN 'Tuesday'
        WHEN DATEPART(WeekDay, getdate()) = 4 THEN 'Wednesday'
        WHEN DATEPART(WeekDay, getdate()) = 5 THEN 'Thursday'
        WHEN DATEPART(WeekDay, getdate()) = 6 THEN 'Friday'
        WHEN DATEPART(WeekDay, getdate()) = 7 THEN 'Saturday'
        ELSE 'wtfo'
      END