Finding dates for previous quarter

[mckenneyj]

Looking for a way to find the starting and end dates for the previous quarter for any year

ex: Today is 6/30/2008. The previous quarter would be the 1st quarter. So I need Starting Date = 1/1/2008 and End Date = 3/31/2008

If today was 1/4/2009 then I would need 10/1/2008 and 12/31/2008

Thanks,
John McKenney
Work Hard... Play Harder

 

[xlbo]

Please post in the SQL Server Programming Forum. This is an SQL issue, not an SSRS issue

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question