|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"SQL Get the last date of the month"
declare @Date datetimeset @Date = '2009/10/17'Select dateadd(day, 0 - day(dateadd(month, 1 , @Date)), dateadd(month, 1 , @Date))
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!