its not the old records that are causing issues. It's every new customer that registers, their agecheckdate is set to 0000-00-00 even though I have set a DEFAULT in the database
I have the DEFAULT already set in db.

Then I create a NEW customer. In the db they are all set to 0000-00-00

.png.022b5452a8f28f552bc9430097a16da2.png)