mrxlsx
Board Regular
- Joined
- Dec 15, 2012
- Messages
- 95
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
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