Get Last Payment Date

[dcbug]

Hi,

I'm trying to the last payment date from a line item file.

I can get the Last(PaymentAmount) but not the date of the last payment.

GetAsNumber ( Last (PaymentAmount ) )

works...

[Ocean West]

Try Max( lineitem::date) or last (lineitem::date) they should work

[T-Square]

I would sort the relationship Date Descending, and take the payment and date from the first record listed.

Stephen--your approach could concievably return values from different records, if for some reason the last record in the result set (from which OP took payment info) did not have the Max(Date).

David

[Ocean West]

@David that stands to reason, thanks :