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:

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:

If you use MySQL as backend:

Not sure about the integrated database.