In our database we have a schema that tells us what date we get an invoice and then another dates schema that converts calender days into a fiscal day of year. For example if we got an invoice on 7/5/2015 and our fiscal year started on 7/1/2015 then the fiscal day of year would be 5. I wanted to find the average day that we get an invoice per account, so to do this I averaged our fiscal day of year results to get a rough projection of when we should expect an invoice in the coming years.
What I would like to do now is look up what my returned average fiscal day of year is and convert it back to a date format. The issue is that the fiscal year begin date can change so I want this value to be looked up in the most current fiscal year.
If more information or pictures are needed to help explain this please let me know,