What should be my data range to build dCalendar table?

[mrxlsx]

Hi Good morning all,

I have a fSa*****ok with columns OrderDate, Products, Delivery Date, ShippedDate.

While DeliveryDate is a promised date to deliver an item, ShippedDate is the date the item got delivered actually. Sometimes items can be shipped a bit earlier or later, sometimes both dates can be same.

In my fSa*****ok, I have my OrderDate range is Jan 01, 2010 to Dec 31, 2012
My ShippedDate range is Jan 27, 2010 to Mar 06, 2013
My DeliveryDate range is Jan 09, 2010 to Dec 31, 2012.

As a best practice, When building the dCalendar table, I thought that I can take my dCalendar table'sdate range from Jan 01, 2010 to Mar 31, 2013 or Dec 31, 2013 (Correct me if I am wrong here).

Question is, What if I take wider range than the current one i.e. Jan 01, 2010 to Mar 31, 2013 both lower side and upper side thinking that some of my future calculations need this range.

Is it a problem? Is it gives any kickbacks somewhere? Any other adverse effects?

Thank you so much for your efforts.
mrxlsx

 

[mrxlsx]

Sorry..a small typo. My Question title should be read as " What should be my date range to build dCalendar table? "

sorry for that.

mrxlsx

 

[scottsen]

The simplest answer is you want your calendar table to cover all dates you "care about". Opinions vary on what that means (Rob Collie loves em real lean... Ken Puls likes them real wide...).