• It sounds like you're asking for something involving a date dimension, maybe start looking at that.