Calculated field based on date range

[brichard]

Hello

I would like to create a query to see what transaction has happened in which tax year.
Transactions
-Transaction ID
-Invoice date - dd/mm/yyyy
-Tax year yyyy

Tax year: calculated, as follows
If Invoice date is between "Invoice year"/06/04 and "Invoice year +1"/05/04 then = Invoice year

I hope it's clear what I am struggling with; thank you for your help.

 

[jdraw]

You may get some ideas from this site re Fiscal Year
http://support.microsoft.com/kb/210249

 

[brichard]

I have found the answer:
financial_year: IIf([invoice_date]>CVDate("5/4/" & Year([invoice_date])),Year([invoice_date])+1,Year([invoice_date]))

 

[jdraw]

Glad you have it working.