How to update a DATETIME field when a checkbox is clicked?

For my Tasks, I have a CompletedDate field and a Completed? field represented by a checkbox on the form. I want to set the Completeddate to the current date when the checkbox is clicked.

This is what you are after: http://brendan-vittum.suite101.com/insert-a-date-stamp-shortcut-in-calc-a110315

Thanks, will look into it. As i was searching, I learned a little about database triggers. Does LO Base support them?

If you use HSQLDB as backend: http://user.services.openoffice.org/en/forum/viewtopic.php?t=25965

If you use MySQL as backend: http://dev.mysql.com/doc/refman/5.0/en/triggers.html

Not sure about the integrated database.

http://user.services.openoffice.org/en/forum/viewtopic.php?t=25965