From 1991, starring Bruce Willis, Danny Aiello and my wife's least favorite person on earth, Andie McDowell. The synopsis doesn't do this movie justice, it has to be seen to be believed.
IMDB gives it a 5.4, Leonard Maltin gives it 2 stars and a pithy write-up, and Rotten Tomatoes gives 22%/53%.