Love-Struck (1997)

A young woman feels that she doesn't believe in love. So Venus, the Goddess of Love, sends her son, Cupid to restore her faith in love but instead gets hit with his own arrow and falls in love with her instead. So, he has a limited amount of time to woo her and decide if he wishes to leave his immortal form and become a regular man. And spend what little time he has with her.