Here's a high level summary of what I'm trying to accomplish:
1. 4-4-5 Calendar that starts on Jan 1, ends Dec 31st (so not a traditional retail calendar) - also, needs to fit with 52 & 53 week years.
2. Calendar must co-operate with 2 different date keys (I have two data sources and I can't concatenate the records)
What's the best way to approach this problem? Every calendar tutorial for 4-4-5 has a traditional calendar that starts in September and ends in April (which is not what we do here).
Would I be using a Link Table for the dates? Everything I try ends in failure. Thoughts? Thanks.
