Unanswered: to retrieve previous year value--Urgent
I need to prepare a crystal report based on the docdate and the quantity.The datevalue is in one table and the quantity in another table. By using inner join i have connected the date and the quantity.But i need to retrieve the previous year quantity in the date value..
for example.. if the datavalue is 23/5/2009 - 200Kg then i need to calculate
the quantity on 23/5/2008-?....... Please quickly reply..