I agree with the previous post that the best way to do this is to create a copy company and copy the GL over to it. Change the fiscal year calendar to your specific dates and then use Sage Intelligence to create the report. Sage Intelligence connectors use period/year and is not date specific; however in your copy company you can configure the period/year to be specific dates. Another more complicated way is to pull in all the GL transactions for a date range but your only going to get the net change for the account and not have BB balance. You would have to figure out how to pull that BB as well to come up with a good ending balance.

I would typically build a model that works off another report that uses formulas for trailing trends keying off an ending date parameter to pull the data.  Let me know if you need more details.