Welcome aboard, young Jedi.

Any chance you could post some sample data? I'm not sure if I understand what you mean or are trying to achieve. (So a simple example would go a long way!)

Something like:

DECLARE @StartDate DATE = '6-1-2013';

SELECT InvoiceNo

, InvoiceDate

, Amount

FROM

(

SELECT 1001 AS InvoiceNo

, '3-1-2014' AS InvoiceDate

, 500.00 AS Amount

UNION ALL

SELECT 1002 AS InvoiceNo

, '3-2-2014' AS InvoiceDate

, 1500.00 AS Amount

UNION ALL

SELECT 1003 AS InvoiceNo

, '6-2-2013' AS InvoiceDate

, 2500.00 AS Amount

UNION ALL

SELECT 1002 AS InvoiceNo

, '3-2-2013' AS InvoiceDate

, 5500.00 AS Amount) x

-- Add one year to the date and subtract one day.

WHERE x.InvoiceDate BETWEEN @StartDate AND DATEADD(d,-1,DATEADD(y,1,InvoiceDate));