Libreoffice Base Default Date Today
Libreoffice Base Default Date Today. LibreOffice Base Tutorial #1 – Basic Functionality. Base is the database component of the free and open-source office. Insert the current date and current time into a new database record? Date' SET DEFAULT CURRENT_DATE. To BASE questions as I go.
Use the following macro code. Here, the table's column (not the control name) is called 'MyDate'.
Sub DefaultDateInForm (oEvent As Object) oForm = oEvent.Source lDateCol = oForm.findColumn('MyDate') If oForm.getString(lDateCol) = ' Then dateStamp = Format(Now, 'YYYY-MM-DD') oForm.updateString(lDateCol, dateStamp) End If End Sub Edit the form, and in form properties, assign the macro to the 'after record change' event. Now, whenever a record's date is empty, such as when a new record is started, the date field should default to the current date.
Libreoffice Base Vs Ms Access
Libreoffice Base Download
There are several discussions about this topic on the openoffice forum:.