Find last day of month

[GreenFella]

Is there a function available to determine the last day of a given month?

I've been searching and come up with nothing.

TIA
Greenfella

 

[JamesLean]

Try this:

DECLARE @date datetime,
	@last_month_day datetime

SET @date = '2005-04-20'
SET @last_month_day = CAST(CONVERT(varchar(6), DATEADD(mm, 1, @date), 112) + '01' AS datetime) - 1

SELECT @date, @last_month_day

--James

 

[hmckillop]

If you create a function which uses the principal 1st of each month is always 01/mm/yyyy. then just use

dateadd(d, -1, mydatefield)

will post a function but not sure what parameter you require.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[vongrunt]

Another way (feat. donutman):

SET @last_month_day = dateadd(mm, 1+datediff(mm, 0, @date), 0) -1

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba