Jan 14, 2019 I created a diary in Libreoffice Base. It has four fields, those being ID, Date, Title, Entry. The ID field is a primary key field that is automatically created, and its field type is 'Integer INTEGER'. The date field is manually entered by me (which I hope to change to being created automatically) and its field type is 'Date/Time TIMESTAMP'. Oct 11, 2016 CURRENTDATE or TODAY default date in Base. Hi Guys, I'm trying to set a default date ( CURRENTDATE or TODAY) ie, Todays date into a date field in a Base Form with. LibreOffice Base Tutorial #1 – Basic Functionality. Base is the database component of the free and open-source office suite LibreOffice, with this solid database.
Hello. I created a diary in Libreoffice Base. It has four fields, those being ID, Date, Title, Entry. The ID field is a primary key field that is automatically created, and its field type is 'Integer [INTEGER]'. The date field is manually entered by me (which I hope to change to being created automatically) and its field type is 'Date/Time [TIMESTAMP]'. The other two are text fields.
Info:
I use Debian 9 (stable), and I use Libreoffice Version: 5.2.7.2
Build ID: 1:5.2.7-1+deb9u4. I have both OpenJDK 1.7 and 1.8 installed (I needed to install and enable 1.7 to be able to update my older LineageOS phone, though I've set LO to use 1.8 --> perhaps I need to change this to 1.7).
Efforts so far:
I tried searching for an answer to this and found the following: https://ask.libreoffice.org/en/quest...ction-in-base/
The suggestion there was to 'place a Text box where you want the date. Then in the fields' Data tab set as follows' ... select the option of TODAY() for it. I was unable to find that option after setting up a text box. The only options were to link to existing fields, so I linked to the date field and basically had an echo of this. Thus, not a solution.
I also tried the option of Insert/Field/Date, but that didn't work.
All ideas appreciated.
Info:
I use Debian 9 (stable), and I use Libreoffice Version: 5.2.7.2
Build ID: 1:5.2.7-1+deb9u4. I have both OpenJDK 1.7 and 1.8 installed (I needed to install and enable 1.7 to be able to update my older LineageOS phone, though I've set LO to use 1.8 --> perhaps I need to change this to 1.7).
Efforts so far:
I tried searching for an answer to this and found the following: https://ask.libreoffice.org/en/quest...ction-in-base/
The suggestion there was to 'place a Text box where you want the date. Then in the fields' Data tab set as follows' ... select the option of TODAY() for it. I was unable to find that option after setting up a text box. The only options were to link to existing fields, so I linked to the date field and basically had an echo of this. Thus, not a solution.
I also tried the option of Insert/Field/Date, but that didn't work.
All ideas appreciated.