SSRS Expression – Number of days in a month.

2017-12-11T11:19:29+00:00 February 14th, 2013|SQL|

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