Looking for second most recent performance year

Hi everyone,
 
I’m attempting to create a report to show when re-engaged (i.e. formerly lapsed) patrons in a current season last attended a performance (by year). I am familiar with the “Years in First Performance Date” and “Years in Most Recent Performance Date,” but does anyone have a handy formula to look at the second most recent performance date?
 
Thanks in advance for any ideas!
 
Best,
Anh
 
signature_1078652768
Anh Le (she/hers/hers)
Director of Marketing & PR
OPERA THEATRE OF SAINT LOUIS
email: ale@opera-stl.org
phone: 314.963.4294 | mobile: 760.834.5926
210 Hazel Ave St. Louis, MO 63119
facebook icon twitter icon youtube icon linkedin icon instagram icon 
 
Parents Reply Children
No Data