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 quarter. What I want to do is return the quarter start date (also in fact table) for the second max quarter (have already worked out latest quarter) that the customers status is either active or inactive?

Cheers