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