About current date in Invoice Forms

Creating and using forms
Post Reply
ywauto
Posts: 1
Joined: Tue Apr 05, 2016 9:10 am

About current date in Invoice Forms

Post by ywauto »

Re: [Example] Invoice Forms (without macros)

how did you set default day = today in your Date field, I cannot find any clues. Please advise.
Many thanks,
Wayne
OpenOffice 4 on Windows 7
Top
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

Re: About current date in Invoice Forms

Post by F3K Total »

Hi,
Tools/SQL... ->

Code: Select all

ALTER TABLE "INVOICE" ALTER COLUMN "DATE" SET DEFAULT CURRENT_DATE
R
  • MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
  • my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
Top
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: About current date in Invoice Forms

Post by Villeroy »

F3K Total wrote:Hi,
Tools/SQL... ->

Code: Select all

ALTER TABLE "INVOICE" ALTER COLUMN "DATE" SET DEFAULT CURRENT_DATE
R
... and leave out the date field on the form or add some a date field with a hint "Invoice date (default: today)"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Top
Post Reply

Return to “Forms”