Return second max date based criteria

Hi all, I am trying to return the second max date that a customer has purchased goods. In my fact table all customers have one of three values 1)in-active, 2) active, 3) partially active for each q...