Convert a date value like 42917 to date

Hi,   One of my columns is formatted as pure date integer like 42917. How do I convert it to date format yyyy/mm/dd ? Using any of the given date formats just give error.   Tks!