SSRS Expression – Number of days in a month.

Tasked with getting all the dates for last month in SSRS without using SQL, just using an expression.
Expression:
=day(dateadd(“d”, -1, Month(TODAY) – 1 & “/01/” & Year(TODAY)))
Can replace the TODAY with a data attribute/parameter if needed.
Cheers

About the author