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 <dbrind...@hotmail.co.uk> wrote: > 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 is the best way to do this in openoffice? > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
