Newbie - simple Query Question - function

SQLServerCentral » Latest topics

Newbie - simple Query Question - function

I want to get the financial Year for a date. I have this:

(Year(DateAdd("m",-3,[MyDate]))) + ' - ' + (Year(DateAdd("m",9,[MyDate])))AS financial_year

But it doesnt work - it adds them together instead of:

2016 - 2017
Each pa

more info...