Get the 2 digit year in T-SQL
You can do ( YEAR( GETDATE() ) % 100 ) + 1
See GETDATE & YEAR
This will work for you
select Right(Year(getDate())+ 1,2)
You can do ( YEAR( GETDATE() ) % 100 ) + 1
See GETDATE & YEAR
This will work for you
select Right(Year(getDate())+ 1,2)