It's a great idea. When implementing it though, be wary when retrieving results for date ranges. Take the example for yesterday:
select
Convert(varchar(100),'Yesterday') as [Period],
convert(datetime,convert(date,getdate()))-1 as...