Error in Date update

Applications Forms
#1

Hi to All,
I have a table in an mySQL DB, that has a column Date.
In my form, in the event “onBeforeUpdate” I have enetered this code:

{user_update_date} = CURDATE();

But, when I try to update a record, this error is returned:
Fatal error: Call to indefined function CURDATE();
Can Someone help me ?
Thank You
Gaetano

#2

The errormessage is correct, there’s no macro or php function CURDATE();
If you want the current date inserted / updated in the database you can set the default values. If you go to ‘edit fields’ you get a list of your database fields. At DBField for insert/update you set ‘value’. Then a pulldown appears where you can set current date.

#3

…If you go to ‘edit fields’…

Thank You. With Your help I have solved.