Query to get the latest date:
Select item, max(inventory_ date)
where inventory_date is < '6/30/2011'
Query to retrieve not more than 6 years from application date:
Select item from a table where appl_date >= (Currentdate - 6 Years)
SQL Query to Selec a date between two dates:
WHERE CP.ActionDate BETWEEN '19/12/2012' AND '1/17/2013'