Difference between revisions of "Documentation/How Tos/Calc: NOW function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
Line 7: Line 7:
 
=== 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 every time 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.
  
  

Revision as of 07:50, 28 December 2007


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.


See also:

TODAY, DATE, TIME

Date & Time functions

Date & Time overview

Personal tools