Hi..
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..

Thank you in advance...
~
Roseline

You can use the dateADD function in crystal reports
DateAdd("Y",-1,{<your Date Field}
Check out for dateadd syntax.

ya.. I have used it to change the date part alone. what i need here is , i want to retrieve the quantity value on that date. How to compare with this date and get..
please....
~
Roseline Christina