Not sure why you should choose the PIVOT syntax, which is horrible in itself (certainly compared to the very elegant and simple TRANSFORM syntax from Jet-SQL).
Unless I'm oversimplifying, this will do the same trick:
SELECT ID, Status, MAX(Date)
FROM PV
GROUP BY ID, Status
Only difference is you get two rows, instead of two columns.

So for a given active date, you want to find the next inactive date, for the same ID?
What about a correlated subquery -
SELECT x.ID, x.Date AS [ACTIVE DATE],
(SELECT MIN(z.Date) FROM PV AS z WHERE z.ID = x.ID AND z.Status = 'Inactive' AND z.Date > x.Date) AS [INACTIVE DATE]
FROM PV as x
WHERE x.Status = 'Active'