• Thanks for the article. I'm actually working on fiscal based periods at the moment, and have opted to have all of the periods defined in a setup-type table.

    E.g.

    Period # | Fiscal Year # | Quarter # | Start Date | End Date

    That way, the end-user is responsible to define the fiscal year, and no calculations are required.

    Your thoughts?