web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / The Dynamics 365 Library / Show last day of the month ...

Show last day of the month from date in SSRS report

Views (5975)
Faisal Fareed Profile Picture Faisal Fareed 10,796 User Group Leader

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

This was originally posted here.

Comments

*This post is locked for comments