Last month Name and Year in a SSRS expression

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

James Goodwin Hall of Fame Points: 3691 More actions · Answer 1

It appears that this will not work in January:

If your AsOfDate = '2011-01-02' you will return 'December 2011' instead of 'December 2010'.

When I am doing something like this, I try to make sure that I am using the same date for both parts, so I would use ...Year(DateAdd("M",-1,...).

--

JimFive

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

SSC Guru

Points: 76202

May 12, 2016 at 6:32 am

Thanks for the script.