window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-108815698-1');

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.
I consent to this website use of cookies and third party services. Accept