I have this formula:

select {PATRNHIST.COURSE}
case "2C00000001":
{PATRNHIST.DATE_COMPLETED}
Case "2C00000002":
{PATRNHIST.DATE_COMPLETED}
case"2C00000003":
{PATRNHIST.DATE_COMPLETED}
case"1C00000001":
{PATRNHIST.DATE_COMPLETED}

Since all four Course Codes make up the BLS Certification course. However, in my report I am grouping on name, then in GH I am doing an Nth Largest is 1 to evalutate the above formula and return the most recent date. Its not working :banghead:

How can I get teh most recent date retunred in Crystal? (Date_Completed)

HELP!! :afro:

Are you trying to pull out the most recent date of the 4 possible dates? If you are, your formula is all wrong.... you have to pull out all 4 of those dates and evaluate them against each other.

May I suggest:
- initialize 4 dates (declare as date variables) to a low date, like 1/1/1980
- Look up all 4 dates
- If a course is found, update its date variable to *whatever it is*
- Finally, do a decision tree to find the latest of the 4 dates.
- Knowing which date, you can then tell what course!
- (Have error handling in case all are still 1/1/1980)

Of course, you could be trying to do something entirely different -- and I have no clue, as usual -- have a NICE day! :rau: