|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"
Select dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(@Date), @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!