• Search Forums
    Advanced Search Topics Posts
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