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

datetime reporting-services ssrs-2008
Cory picture Cory · May 17, 2010 · Viewed 52.2k times · Source

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

Answer

Cory picture Cory · May 17, 2010

Here is the answer I came up with

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

Related questions

How to calculate number of days by two dates in SSRS formula field

I have an SSRS report and I have a table there, in which I have a column named as No. Of Days which are lying between two dates. I am getting those dates (datetime) through datasource but don't know how …

Read More
How to get the current time in Python

What is the module/method used to get the current time?

Read More
Converting string into datetime

I've got a huge list of date-times like this as strings: Jun 1 2005 1:33PM Aug 28 1999 12:00AM I'm going to be shoving these back into proper datetime fields in a database so I need to magic them into real datetime objects. This …

Read More