For Base:
In dialog Execute SQL:
ALTER TABLE "Customers" ALTER COLUMN "Date" DATE DEFAULT CURRENT_DATE; //full
declaration with type and default
OR
ALTER TABLE "Customers" ALTER COLUMN "Date" SET DEFAULT CURRENT_DATE; // modify
the default only
On 2020/11/12 08:04:03, DAB DAB wrote:
> H
u wanted. It is probably something that can be achieved but others
more knowledgable than me will know.
Alan
Original message
From: Joost Andrae
Date: 12/11/2020 11:37 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: Default Value field in a table formatted to Date
)
To: users@openoffice.apache.org
Subject: Re: Default Value field in a table formatted to Date
Hi,I'm not quite sure what you like to accomplish.Within Calc you can use the
formula TODAY()So if you enter =today() into a cell you'll get the current
date.If you save this within a sprea
Hi,
I'm not quite sure what you like to accomplish.
Within Calc you can use the formula TODAY()
So if you enter =today() into a cell you'll get the current date.
If you save this within a spreadsheet document and if you load that
document then this cell will show you the current date.
Kind re
Hi, I am new to openoffice and have used MS Access in the past. I have created
a table called Customers and have 3 fields CustomerID, Name and Date. The date
field type is date. When I open the table I want the Date field to default to
today’s date so I don’t have to keep inputting a date.
What
