gh-70647: Raise a more informative error for when date is out of range

gh-70647: Raise a more informative error for when date is out of range #69342