Create Fiscal Year Based On Specific Start Date
I need help with Dates in FM Pro. I'm trying to figure out how I can set a specific date as the start of the year, like a fiscal year of some sort. That way, I can then attach week numbers to dates based on the "fiscal year" that I've created instead of the week numbers relying on "calendar dates".
Example: 25 September 2011 actually falls in "Week 40 of Year 2011". I want to be able to tag that same date as "FiscalWeek 1 of FiscalYear 2012". And 29 September 2012 as "FiscalWeek 53 of FiscalYear 2012" and not "Week 39 of Year 2012".
Thanks in advance!