SSRS Expression – Number of days in a month.

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

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

Leave A Comment

like what you see? 

Sign-up to our newsletter and never miss out on the latest blogs, events and tech news from the world of risual
SUBSCRIBE!
Give it a try, you can unsubscribe anytime.