PreviousQuarter

April 19, 2004

>>Script Language and Platform: SQL Server 2000
This script will return you to the first day of previous quarter of a given date.

--today's date Apr 19, 2004
select dbo.previousquarter (getdate())
--returns 2004-01-01 00:00:00.000

select dbo.previousquarter ('03/31/2004')
--returns 2003-10-01 00:00:00.000

select dbo.previousquarter ('04/01/2004')
--returns 2004-01-01 00:00:00.000

select dbo.previousquarter ('07/11/2004')
--returns 2004-04-01 00:00:00.000

select dbo.previousquarter ('09/09/1974')
--returns 1974-04-01 00:00:00.000

Author: The MAK

Create function dbo.previousquarter (@date datetime)
returns datetime
as begin
--Author -MAK
--Objective-- To return the first day of previous quarter of a given date
declare @month tinyint
declare @year int
declare @returndate datetime
if month(@date) between 1 and 3 begin set @month=10 set  @year=year(@date)-1 end
if month(@date) between 4 and 6 begin set @month=1 set  @year=year(@date) end
if month(@date) between 7 and 9 begin set @month=4 set  @year=year(@date) end
if month(@date) between 10 and 12 begin set @month=7 set  @year=year(@date) end
--print @month
--print @year
set @returndate = convert(datetime,right('00'+convert(varchar(2),@month),2)
   +'/01/'+convert(varchar(4),@year))
return @returndate 

end

Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness, or fitness for a particular purpose... Disclaimer Continued

Back to Database Journal Home