If you are going to create one it is usually useful to create it with may coulmns with different dateparts so you can use that as metadata for other things but it is not necessary.
One row per day back to where your overall DB data setsd start
mine ends in 2029 but I rarely need to look more than 2 years out.
as time moves on you likely will change your DB but you can alwasy append to it as needed.
Column ideas
DATE as DATE
DATE as DATETIME
YEAR
MONTH
MONTH NUMBER OF QUARTER
WEEK NUMBER OF YEAR
DAY NUMBER OF YEAR
MONTH ANME
DAY NAME
HOLIDAY / IS WORK DAY
Edited by DBlank - 08 Dec 2014 at 5:39am
IP Logged
