Lindsay,

Is dbo.DimDate a table that has a row for every date?  With our 4-4-5 periods, we created a lookup table with a row for every date from 1-1-2000 thru 1-1-2025. ...