Apache OpenOffice (AOO) Bugzilla – Issue 100229
In a date field (with no default date registered) in a form, the current date isn't displayed
Last modified: 2013-02-07 22:36:36 UTC
When I use a datefield in a form based on a table, I can't have the current date displayed by default. For this datefield, I leave blank the propertie "Default Date". I think it's a regression. It's impossible to write for this properties a string like "Today()" : perhaps it could be an improvement.
Created attachment 60947 [details] A database with a form based on a table, where there is a date field which should display the current date
This is not a regression - rather is by design. Date controls did at one time default to the current date, however due to user requests, this was removed. You have two choices now: 1 - you can call a macro to fill the date control w/ the current date. 2 - you can set the default for CURRENT_DATE at the column in the databse engine. (this requires the use a SQL command from within the SQL window in Base) Using this solution will mean though that the date will not be displayed in the GUI unitl AFTER the record has been posted to the database. @thierrym - With regards to this Issue then - As a defect I would call this INVALID but if you prefer (and I would suggest).. Remove the keyword regresson. (actually I'll do that now) Change it from defect to enhancement asking for an option to be added to the date control.
@atjensen, Sorry for the lag... I changed the issue type for Enhancement