birthdays are incorrect

[mm00re]

A year ago I imported users into vb from an old SMF forum and almost 3600 users are set to a birthday of 01-01-0001 and i don't want a mass spamm going out this new years to all of these people. Is there a way to do a mass change so it just removes the birthday or anything like that?

Thanks! :)

[Seven Skins]

You can run a query to delete incorrect birthdays.

e.g UPDATE user SET birthday="" WHERE birthday="0001-01-01"

But I am not very good with mysql queries someone with more knowledage about them can give you correct query or correct the above one.

[Dismounted]

Are you sure the date wasn't 01-01-1970?

[mm00re]

yes I went into many of the records and it showed to be 01-01-0001 and in the birthday_search field it was 0001-01-01

I wound up just making a backup of my database, modifying an sql statement to edit all 3200 users instead of 1 and modified both fields so it won't send out the b-day notice.

I definitely think there should be some sort of a control panel option to check birthdays, even as maybe a plug-in or hack