RE: Finding Last Day Of the systemdate

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 08:57:04 -0700

Try this:

DATEADD(MONTH,1,DATEADD(DAY,-DAY(CURRENT_TIMESTAMP),CURRENT_TIMESTAMP)) 

-- 
David Portas
SQL Server MVP
--