I have figured out how to create a table that holds calendar dates, day, day of week, week number, quarter, year, etc. What I need to do is to ad fiscal year columns to the calendar table. The problem is that our fiscal year starts the first Sunday of January, i.e. 2009 fiscal year is 1/4/2009 - 1/2/2010, 2010 fiscal year 1/3/2010 - 1/1/2011, and 2011 fiscal year 1/2/2011 - 12/31/201. We also run a 4-4-5 week periods. I need to be able to calculate all of the fiscal year information and put it in the calendar table. Any suggestions on how this can be done?
Thanks in advance for the help.