<div>
<div class="content wysiwyg-content">
I am using the following query to bring back data from the start of the year to the end of the last month.<br />
<br />
The date is datetime field<br />
<br />
where &nbsp;year(acd.startdatetime) = year(getdate()) and &nbsp;month(acd.startdatetime) &lt;= Month(getdate()) - 1<br />
<br />
I now need to a query to bring back the last full years data i.e. 2006 Jan 1st - Dec 31. This will then be run on the 1st of January every year to bring back the previous years data.<br />
<br />
Can anybody help?<br />

</div>
</div>


I am using the following query to bring back data from the start of the year to the end of the last month.

The date is datetime field

where  year(acd.startdatetime) = year(getdate()) and  month(acd.startdatetime) <= Month(getdate()) - 1

I now need to a query to bring back the last full years data i.e. 2006 Jan 1st - Dec 31. This will then be run on the 1st of January every year to bring back the previous years data.

Can anybody help?


Date Query - Last Full Year

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.