datetime - How do I get the last day on the month using SQL Reporting Services

Question

In SQL Server Reporting Services, how would I calculate the last day of the current month?

Answer 1

Here is the answer I came up with

=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(1).AddDays(-1)