Ask Your Question

Is there an autodate function in Base? [closed]

asked 2018-01-21 16:18:55 +0200

ranril gravatar image

I frequently update my Base Table of 600+ records. I then create a new Base Report File for my high school classmates. I would like to place an auto date function in the footer to indicate date of change. I now add this date manually. Is there a function to do this automatically (similar to a spreadsheet function like @date() )? Thanks for your reply - RANRIL

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by ranril
close date 2018-01-25 16:12:35.422298

1 Answer

Sort by » oldest newest most voted

answered 2018-01-21 16:46:45 +0200

Ratslinger gravatar image

updated 2018-01-21 19:38:58 +0200


Please see answer posted here.


To make this clearer, place a Text box where you want the date. Then in the fields' Data tab set as follows:

image description

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more


Thanks for confirming auto date function TODAY() is available. However, being new to LO, how do I get to "fields' Data tab you gave a screen shot of? Ranril

ranril gravatar imageranril ( 2018-01-22 01:41:50 +0200 )edit

Two ways. Each starts with selecting the field you added. Now either right mouse click & select 'Properties' or select Properties icon on toolbar. These are both toggles. Click again & properties turn off.

You should check out docs here - Chapter 6 is Reports.

Ratslinger gravatar imageRatslinger ( 2018-01-22 01:52:07 +0200 )edit

Ratslinger, I originally asked to insert todays date in a "Footer". All you have to do, after watching a googled video, is to select the footer in Report edit mode. Then select "Insert Field" & then select "Date" from the window that opens on the right. Todays date is entered at point of the cursor. I'll have to wait until tomorrow to see if date changes to tomorrow. All is fine as date automatically changed. Thanks -ranril

ranril gravatar imageranril ( 2018-01-25 16:06:14 +0200 )edit

@ranril There is always more than one way to accomplish the same thing. Placing the current date is the same no matter where it is placed. One point, on my LO v5.4.3.2 (Linux) I have nothing called Insert Field. Instead, from menu, selecting Insert->Date and Time... and selecting Include Date produces what you state. Result is identical to what is in my answer.

Ratslinger gravatar imageRatslinger ( 2018-01-25 16:23:42 +0200 )edit

Question Tools

1 follower


Asked: 2018-01-21 16:18:55 +0200

Seen: 140 times

Last updated: Jan 21 '18