Previous Year

[tmumaw]

This statement gives me current year, but I need previous year.  What do I need to change to get it.

Thanks

Date((monthname(Today())-1),'MMM YYYY')

[rajni_batra · Accepted solution]

Date((monthname(AddYears(Today(),-1))),'MMM YYYY') 

or

Date((monthname(AddMonths(Today(),-12))),'MMM YYYY') 

[israrkhan]

Like below

=Year(Date)-1 OR

=Date(Year(Today())-1, 'YYYY')  OR

=Year(Date(Year(Today()))-1 )

[tmumaw]

Thanks Rajni.....just what I needed.