I would like the date column to automatically add the current date when  row of data is added. Please advise.

What kind of data source are you using?

Hi Johannes,

Johannes I am using MySQL as the data source.

Hi Milan.

Your response time is fine, thank you.

This seems so simple. There should be a way to add =NOW() for datetime fields.

MySQL allows this to be done for timestamps and datetime during the creation of the table.

CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

A standard practice in data structure design is to have an identity column and a datetime stamp. These two columns insure 1st normal form is enforced automatically. It also is extremely useful for identifying when a record was created.

My workaround at this point is to add the field to the end of the table, and force it to fill in. I have seen that it auto populates but a user can change the data, which is very bad for data integrity issues. I had hoped your solution would eliminate coding custom forms, but clearly I am wrong about that.

I understand that you don't support it, but it makes no sense to me that something this fundamental is missing. 

Hi jhilburn,

simply modify your table in SQL backend and add a column which is defaulted to the current timestamp:

ALTER TABLE t1 ADD `createdon` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Please note that I am not an official support user. I am a customer just like you, trying to help out. ;-)

Regards,

Johannes

Hi Johannes,

I should have thought of that myself. I tried to modify the column I created through wptables the first time around but it would not update. Adding a column in this manner makes total sense. Thank you for the tip!