declare @today dateTime = getDate() declare @today_F varChar(11) = convert(varChar(11), @today, 101)

declare @this_year varChar(4) = datePart(yy, @today) declare @Jan_01 varChar(11) = '01/01/' + @this_year

declare @Julian int = dateDiff(dd, @Jan_01, @today_F) declare @Julian_Plus int = @Julian + 1000

declare @Julian_Plus_F varChar(4) set @Julian_Plus_F = convert( varChar(4), @Julian_Plus )

declare @Julian_F varChar(3) set @Julian_F = right(@Julian_Plus_F, 3)