We currently have a financial year in the company I work for starting 1st May running through to 30th April
In the query I am developing I need to have a start date of the beginning of the financial year, 2 financial years ago
At the moment I add it in myself
i.e declare @start datetime = '01-May-14'
I want to add something that will automatically calculate the start date.
Can anybody help?