making auto increment date in openoffice base

Please note that all contributions to The Document Foundation Wiki are considered to be released under the Creative Commons Attribution-ShareAlike 3.0 Unported License, unless otherwise specified.Based on work by Ilmari Lauhakangas and Raal Raal and others. This page was last edited 11:07:41, by Han V.The user can insert the date with one mouse-click: The formula TODAY() returns the number corresponding to the date since the 'origin' date, The formula TEXT() presents this number in the desired format. In the Source box, type TEXT(TODAY() 'JJ/MM/AA').On the Criteria tab, and the Allow listbox, choose Cell Range.Select the cell or range of cells concerned and go to Data ▸ Validity.

There are two possibilities: creating a dropdown list in the cell or using a 'Calendar' control. The default format applied is dd/mm/yy for the date and hh:mm:ss for the time respectively, when only the chosen part is displayed. In both cases the value contained in the cell is in the format dd/mm/yyyy hh:mm:ss. The simplest and quickest solution is to use the default key-bindings defined by: The functions TODAY() and NOW() calculate the current date and time automatically but, by definition, these values are automatically recalculated and are not 'fixed'. How to insert a fixed date or time Problem 1.4 Insertion using a timestamp formula.

Making auto increment date in openoffice base