Q1) In Base table Edit, for a “Date/Time [ DATETIME ]” type field, under Default value, how to I set the date/time to now, as in right this second, or =now()?
The only thing I can seem to enter for a Date/Time [ DATETIME ] field in the Default value box is an integer. Can one calculate a default value? There doesn’t seem to be any relevant help via F1 for the “Default value” input box.
I am converting a bunch of databases from MS Access and have many tables containing a Created field. In MS Access this is set to =Now() or similar functions.
Q2) Similarly, I have some fields named “Edited” that want to get updated with the date/time stamp when the record is edited. How do I do that? (This might have to be done at the Form level via an event, but I think the the Created fields in Q1 should be done at the Table level if at all possible.)
Using LO 188.8.131.52 on a MariaDB 10.1, but I would like a solution that is universal if at all possible.
This is really the same exact question, as was closed without ever being answered here.