I'm working on a client report that needs statistics on number of days in inventory, number of days in Accts Pay, Number of days Accts Rec. etc.

To do the calculations each reporting period I need to calculate the number of days from the start of the fiscal year to the end of the reporting period.

For example a year end of Sep 30. Reporting period for the period Oct to Dec 2007 would calculate Oct 1 to Dec 31 = 91 days.