? on Setting default value to Year of previous month

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

jbalbo SSCertifiable Points: 7580 More actions · Answer 1

It's funny, when you see something in print, you get it....

I came up with

=Format(DateAdd(DateInterval.Month, -1, Today), "yyyy")

And it works!!!

Thanks

Steve Collins SSCrazy Points: 2068 More actions · Answer 2

select year(eomonth(getdate(),-1))

Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

jbalbo SSCertifiable Points: 7580 More actions · Answer 3

Thanks Steve, thats a bit more straightforward 🙂

Jeffrey Williams SSC Guru Points: 90252 More actions · Answer 4

In SSRS:

=Year(Today.AddMonths(-1))

=Today.AddMonths(-1).Year

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll