I guys i have a table expenses with multiple records.
expenseID ratename description workcompleted 51699 Base Rate SNL Financial inquiry 08/09/2011 51699 Base Rate SNL Financial inquiry 08/19/2011 51699 Base Rate SNL Financial inquiry 08/09/2012 51699 Base Rate SNL Financial inquiry 08/19/2012 But when i search record only for year 2012 but it return record for both the year(2011, 2012). But i need my record comes by year only i.e. 51699 Base Rate SNL Financial inquiry 08/09/2012 51699 Base Rate SNL Financial inquiry 08/19/2012 Please see my query : select expenseid,ratename,description,workcompleted from EXPENSES where workcompleted >= '08/08/2012' and workcompleted <= '08/19/2012' I also try this by using between query but it doesn't work. If any body have an idea kindly share to me.
select expenseid,ratename,description,workcompleted from EXPENSES where workcompleted >= '2012/08/08' and workcompleted <= '2012/08/19'
select expenseid,ratename,description,workcompleted from EXPENSES where year(workcompleted)='2012'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)