Editing the year of Leads date created via a Logic Hook

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

I need to edit years from imported leads that have the year “0018” into “2018”

It is my understanding that I can easily get the date of a created lead in a logic hook with $bean->date_created;

But how do I access the year and simply replace the first 0 with a 2? (If it is a 0 of course)

Thanks

#2

The easy way would have been to fix the data on a spreadsheet, before the import.

But now, if I were you I would do an update (carefully) from SQL with phpMyAdmin.