Difference between revisions of "Documentation/How Tos/Calc: TODAY function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| Line 3: | Line 3: | ||
== TODAY == | == TODAY == | ||
Returns the current date and time | Returns the current date and time | ||
| − | |||
=== Syntax: === | === Syntax: === | ||
<tt>'''TODAY()'''</tt> | <tt>'''TODAY()'''</tt> | ||
: returns the current date (as a date-time serial number). <tt>'''TODAY'''</tt> is updated at every recalculation, for instance if a cell is modified. | : returns the current date (as a date-time serial number). <tt>'''TODAY'''</tt> is updated at every recalculation, for instance if a cell is modified. | ||
| − | |||
=== Example: === | === Example: === | ||
<tt>'''TODAY()'''</tt> | <tt>'''TODAY()'''</tt> | ||
: when calculated at say 12 noon on 1Apr08 returns 1Apr08. | : when calculated at say 12 noon on 1Apr08 returns 1Apr08. | ||
| − | |||
=== See also: === | === See also: === | ||
Revision as of 14:41, 15 January 2008
TODAY
Returns the current date and time
Syntax:
TODAY()
- returns the current date (as a date-time serial number). TODAY is updated at every recalculation, for instance if a cell is modified.
Example:
TODAY()
- when calculated at say 12 noon on 1Apr08 returns 1Apr08.
