Product add date as update date

[mkmk]

Hi guys.

I have many products need preparation, so they are inactive until all informations has been added. I would like to change add_date for present when I click on Active on product card. I found this topic :

 

Vekia posted SQL trigger but it doesn't work on Presta 1.7.7, I'm getting message "#1064 - Something is wrong in your syntax obok 'END IF"

Do you have any solution to fix it?

Thanks in advance