• A common technique in the data warehousing world is to create a dates or calendar table that list all the possible permutations of a date. ie.:

    date

    calendar year

    fiscal year

    calendar quarter

    fiscal quarter

    calendar month

    fiscal month

    day of calendar month

    day of fiscal month

    day of calendar year

    day of fiscal year

    etc. Then query the table with a where = Getdate() and it returns all permutations of a date. This approach also makes date range queries easy, instead of WHERE DATE BETWEEN 1/1/11 AND 3/31/11

    you could use WHERE FiscalQuarter = 201101.