First/Last Days in Current Quarter? 1

[Yerdon]

Hi Everyone,

I am using

datename(quarter,getdate())

in order to find the current fiscal quarter.

Is there an easy way to get the first and last dates in the current quarter? For example, if today is 8/6/09, then the first date in the quarter would be 7/1/09 and the last date would be 10/31/09.

Any help would be really appreciated.

Thank you!

Joseph

 

[gmmastros]

try this:

Select DateAdd(Quarter, DateDiff(Quarter, 0, GetDate()), 0)
Select DateAdd(Quarter, 1 + DateDiff(Quarter, 0, GetDate()), -1)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Yerdon]

Thank you! That works perfectly!!!