Does anyone know if it is possible to set a database up to use April to March as the year instead of January to December. It's not a major problem as far as working with the dates, but I also want to use week numbers on a report, and I'd like week 1 to be in April. I have thought that I could just take 3 months from the date I want to display, to make it display as the correct week in the financial year, but that's not really ideal.
Financial Year
- Thread starter stephen81
- Start date
Mile-O
Back once again...
- Local time
- Today, 20:50
- Joined
- Dec 10, 2002
- Messages
- 11,316
This thread gives criteria for such a financial year.
If you set the start date to be April 1st of any year then you can use the DateAdd() function for periods within the financial year.
If you set the start date to be April 1st of any year then you can use the DateAdd() function for periods within the financial year.
