I've only seen two of the films and never read one of the books but it came up in a quiz on Tuesday and the whole team thought he was a schoolboy so how did he have kids? Google was useless on this
This was in the Epilogue at the end of the Seventh Book. it was 19 years later and told us what had happened to all the characters in the last 19 years.