InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:31:53 GMT20http://www.sqlservercentral.com/Forums/Topic1404621-391-1.aspxThanks Friends!It works for me.Wed, 09 Jan 2013 04:07:34 GMTavdhut.khttp://www.sqlservercentral.com/Forums/Topic1404621-391-1.aspxI agree with Anthony... a calendar table is probably a better idea, but this should get you the first day of the previous quarter.[code="sql"]declare @d datetimeset @d = getdate() -- or whatever date you want to testselect DATEADD(quarter,DATEDIFF(quarter,0,@d)-1,0)[/code]Wed, 09 Jan 2013 03:54:22 GMTIan Scarletthttp://www.sqlservercentral.com/Forums/Topic1404621-391-1.aspxI would say this is where a calendar table like this one will come into best fit. [url]http://www.sqlservercentral.com/scripts/Date/68389/[/url]Then you can query it to find todays quarter, then lookup the previous quarters first day.Wed, 09 Jan 2013 02:53:54 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404621-391-1.aspxHi, I am using Sql server 2008, My requirement is to find the first date of the previous Quater of the given date.Example,Givendate Quater Required Output2013-01-20 1 2012-10-012013-03-20 1 2012-10-012013-04-10 2 2013-01-012012-10-10 4 2012-07-01Please Help me,As I need this very urgently.Thanks in Advance!Wed, 09 Jan 2013 02:44:07 GMTavdhut.k