Monday, May 18, 2015

Show last day of the month from date in SSRS report

Following expression can be used to show last day of the monthin SSRS report.


Format(DateSerial(Year(Parameters!Dataset1_AsPerDate.Value), Month(Parameters!Dataset1_AsPerDate.Value),"1").AddMonths(1).AddDays(-1),"dd/MM/yyyy")

Input:  Parameters!Dataset1_AsPerDate.Value = "02/01/2015"
Outout: 31/01/2015

1 comment:

  1. I have been looking for the answer to this problem and yours is the only one that has worked for me! THANK YOU!!!

    ReplyDelete

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...