select second last date

[#1]

hello.

i have a table with 2 fields: donation place, donation_last_date.

the last date field works ok.

the problem is when a donation was cancelled it still shows me the last donation date and i would like to show only the last donation date for a donation that was not cancelled. it could be the second max date or the third.

place	donation_last_date
A	25/05/2015
B	01/06/2016
C	12/10/2015
D	09/08/2014

now if donation A and B were cancelled i would like to show the previews donation date that was not cancelled

thanks

for donation A i have those dates:

25/05/2015 -cancelled

22/04/2015 -cancelled

10/04/2015 -donation done

[#2]

i have a field called donation_status

[Anonymous]

Hi,

If you do have a field, what's it called ?  Can you upload your qvw file ?