The Flintstones: Fred's Final Fling (1980)

Due to a mix-up at the doctor's office, Fred believes he has only 24 hours left to live.