Problem related to getting date

[biswa47]

Hi friends I want to select two date from sys. 1st date is 1-April-2007 where Day 1st= is fixed Month April is also fixed But Year 2007 is the current year-1 and the 2nd date is 31-Dec-2007 where day 31st/30th/28th/29th is the last day of the previous month.means current month -1 and Year 2007=Current year-1 for the month of January and for the other months its fixed that is 2008 menas the current year. well i am using SQL SERVER 2005.pLZ help me out.

[Ashfield]

I think this will do it - it looks a bit horrendous and I'm sure there must be an easier way :sigh: declare @start datetime, @end datetime, @month varchar(10) set @month = 'feb' select @start = convert(datetime, '01-Apr-' + convert(varchar,datepart(year,dateadd(year,-1,getdate())))) select @start select @end = convert(datetime,dateadd(day,-1,dateadd(year,1,convert(datetime, '01-' + @month + convert(varchar,datepart(year,dateadd(year,-1,getdate()))))))) select @end

Bob Ashfield Consultants Ltd