Have report that is linked to a table called "fiscalperiods" that has all the start and end date for each fiscal month and quarter of the year it belongs. I need this report to also pull data for the current quarter in the select expert so that i dont have to update each quarter.
Fiscalperiods table fields:
Begindate (begin date of the fiscal month)
Enddate (End date of the fiscal month)
Fiscalmonth (fiscal month number)
fiscalyear (Fiscal year)
qtr (quarter the fiscal month is in)