Get the 2 digit year in T-SQL September 5, 2023 by Tarik You can do ( YEAR( GETDATE() ) % 100 ) + 1 See GETDATE & YEAR