Accounting Year Query

[RFH Reseller: spire128]

I am trying to design a query that will return tranactions in my current accounting year.

So I have the accounting year start date, 1/4/2007 in a table called accounting_year.

The Accounting year will run from the the Year Start Date to 31/3/2008 in this case.

I am using DATEPART(Month,TranactionDate) = @iCurrentMonth to enable me to select any months data within the current accounting year.

So the bit I am having trouble working out is how do I make the query select months within the accounting year,

Any Help Appreciated

Thanks

[RFH Reseller: marty101]

Where clause using BETWEEN..

something like

Where DateField BETWEEN CONVERT(DATETIME, '06/04/2006 00:00:00', 102) AND CONVERT(DATETIME, '05/04/2007 23:59:59', 102)

[RFH Reseller: askjim]

you can use getdate() to get the current date and then extract the year number from it. This would then help you construct the start date which always would be 1/1 and append the year from get date.

You would then use getdate() as the end date.

[RFH Reseller: spire128]

Hi

Thanks for your help Marty101 your solution with a bit of adaptation has done the trick.

I can't use getdate() as the accounting year start date will be agreed between myself and the accounant and will be a fixed point in time that everthing else will be reffereced of, such as turnover for the year etc .

Many thanks both