NewFocusConsult
asked on
How to get Max Date
Hello
I am trying to derive the Maximum Date where a document type is equal to a particular value
For instance
Maximum ( Doc_Date_ where doc_type = 'CPAY'
How can I do this calculation within a Crystal report?
I am trying to derive the Maximum Date where a document type is equal to a particular value
For instance
Maximum ( Doc_Date_ where doc_type = 'CPAY'
How can I do this calculation within a Crystal report?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you grouping by document?
Without a group you can only get the maximum of all the data.
mlmcc
Without a group you can only get the maximum of all the data.
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Basically there is a list of documents with different doc types, the report is sorted by date and I need to work out the last date of a particular doc type and do a DateDiff to today and calculate the datediff by a daily rate which is already calculated.