Calculating non-standard WTD & MTD

[waterboy1628]

I'm working on a project and I would like to be able to choose from a drop down menu to show week-to-date, month-to-date, and year-to-date data.

I would just use the month now function, but I want to show the data by a company's FISCAL weeks and months. Example, Week 1 would be from 6/23 to 6/29. Month 1 would be 6/23 to 7/20. For my intents and purposes, Year-to-date is a non-issue because it will just be all-inclusive of the my data.

In MS Access, I've made a Date Fact Table which matches standard days, weeks, and months to fiscal days, weeks, months.

I'm just not sure of the next step.

Thank you.

[waterboy1628]

I figured it out.

I can just use my date fact table in MS Access. Using the Date() function in the criteria, I can return the current Fiscal Week and Fiscal Month and refresh that into Excel each time I open my file.