Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Issues in Crystal Report

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
dipu
Basic Member
Posts: 9
Basic Member
4/28/2010 10:40 AM
    How can I get the max value of check-date in lawson 9 with crystal reports9. I created a report how ever it is not showing the correct value. Please help.
    The condition I need is the max( check-date)<= currentdate - 90
    Char
    Veteran Member
    Posts: 62
    Veteran Member
    4/28/2010 10:47 AM
      Write a formula " if checkdate <= currentdate - 90 then checkdate else date(1900,01,01) " then do a max of that formula