Get year of prior month

EricLynnWright
EricLynnWright used Ask the Experts™
on
How do I get the year (as four digits) of the prior month?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
could be ...
select year(DATEADD (m , -1 , getdate() ))

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial