Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    4

    Unanswered: to retrieve previous year value--Urgent

    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

  2. #2
    Join Date
    May 2009
    Posts
    5

    Thumbs up

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

  3. #3
    Join Date
    Jun 2009
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •