<div>
Select * <br />
From Table A <br />
Where fundeddate&lt;DATEADD(month,-<wbr />14,getdate<wbr />())
</div>


Select *
From Table A
Where fundeddate<DATEADD(month,-14,getdate())

<div>
<div class="content wysiwyg-content">
I have a query that currently pulls all data since May of 2005. &nbsp;The report that utilizes this data only needs 14 months of data to run. &nbsp;How can I set up the query below to pull only the last 14 months of data going back from the current date? &nbsp;Preferably the solution will be placed within the where statement. &nbsp;All queries are run from MS Query within Excel XP. &nbsp;Thanks in advance.<br />
<br />
<br />
Select * <br />
From Table A <br />
Where fundeddate&gt;'20050430'
</div>
</div>


I have a query that currently pulls all data since May of 2005.  The report that utilizes this data only needs 14 months of data to run.  How can I set up the query below to pull only the last 14 months of data going back from the current date?  Preferably the solution will be placed within the where statement.  All queries are run from MS Query within Excel XP.  Thanks in advance.


Select * 
From Table A 
Where fundeddate>'20050430'

Retrieving last 14 months of data with SQL statement

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.