The last time I was sober on New Years Eve was when 1988 turned to 1989.
Over the last 27 years I was usually passed out drunk before midnight.
I think the last time I was out somewhere and awake at midnight on New Years Eve was when 1999 turned to 2000. Since then I was usually at home passed out or out of town passed out in some hotel room.
This year my wife and I are going out to dinner at an expensive restaurant - and odds are pretty good that I will be asleep at midnight - and sober.