Update Timestamp

craigbert · February 19, 2020, 6:49pm

Hello All,I have another simple question that I can’t figure out.
I have an update timestamp column in a table.
In Fields I have the Auto-Update Value set to “CurrentDateTime()”. I also have the same value set for the Add.
But no matter how often I update the record the update timestamp never populates.Any thoughts about where I am going wrong?Thanks.

sticcino · February 20, 2020, 12:24am

did you add it to the “Default Value” field under “Add Page” Heading on the Fields Tab ?
this will set the your field name to the value specified to this value when a record is created

craigbert · February 20, 2020, 12:48am

Hi sticcino,Yes I did that and it populates on ADD, but the Edit function doesn’t update the timestamp on SAVE.Thanks.

mobhar · February 20, 2020, 1:01am

Simply put this in “Row_Updating” server event:$rsnew[“MyField”] = CurrentDateTime(); // adjust “MyField” to your actual field name

craigbert · February 20, 2020, 2:31am

Thanks, that did it!
My first project is moving along thanks to you guys, I really appreciate it.Sincerely,Craigbert