Description:-
In this article we will see about hoe to get only year in SSRS report. here I have display only year 2 digit in SSRS report. using expression how to get it. here is the solution to get year 2 digit. it could be current year or previous year or next year. here is the expression to get year 2 digit. Here my current year is 2016.
Expression:-
Output:- 16
Output:- 2016
Output:- 2015
Output:- 2015
Output:- 2017
Output:- 17
Output:- 17
Output:-16
In this article we will see about hoe to get only year in SSRS report. here I have display only year 2 digit in SSRS report. using expression how to get it. here is the solution to get year 2 digit. it could be current year or previous year or next year. here is the expression to get year 2 digit. Here my current year is 2016.
Expression:-
=Format(CDate(today()), "yy")
=Year(today())
today().AddYears(-1).year
CStr(Year(Today)-1)
today().AddYears(+1).year
=Format(CDate(year(today())+1), "yy")
Format(Year(today())+1).Substring(2)
Format(Year(today())).Substring(2)
Thanks for comments.....