Retrieving previous month end date

[llafretaw]

Hi,
I'm trying to set the date of a particular parameter to a value that is roughly the month end of the previous month
I've tried doing syntax such as:
select @m.date = datepart(mm - 1, getdate())
If @m.date <> 2
BEGIN
select @r.date = '30' + @m.date + datepart(yyyy,getdate())
END
ELSE
BEGIN
select @r.date = '28' + @m.date + datepart(yyyy,getdate())
END

Any help would be welcomed

 

[mikewoodhouse]

Try this:

select DateAdd(day, -1, convert(datetime, '1-' + datename(month, getdate()) + '-' + datename(year, getdate())))

...so we make a string that's the first day of the current month, convert it to a datetime and subtract a day.

HTH,

Mike