OK

this is where i am at and stuck

declare @period_name as date = 'DEC-10'

case when substring(period_name,5,2) = '@periodname' THEN SUBSTRING('@periodname' ,5,2)

the period names are in format DEC-01,...