Select Newest Date

[bld21]

I am using crystal reports 2008. I have a formula named @DATE with the following :

if (isnull({vehicle_lease_end.turn_in_dte}) or {vehicle_lease_end.turn_in_dte} = Date(1900, 01, 01)) then
{account_termination.term_dte} else {vehicle_lease_end.turn_in_dte}

The problem I have come across is that some accounts have more than one date. I would like to only see the account with the most current date and not all of them.

Thanks,
Bruce

 

[lbass]

Assuming you have a group on account, go to report->selection formula->GROUP and enter:

{@DATE} = maximum({@DATE},{table.account})

-LB