Input is not recognised as date so is converted to Long (10120133) and then Format will try to convert this to date value. Maximum permitted value for date value is 31 December 9999, which is 2958465 as Long. Therefore overflow occurs.