Documentation/How Tos/Calc: NOW function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 07:31, 17 July 2018 by
Sancho
(
Talk
|
contribs
)
(
diff
)
← Older revision
|
Latest revision
(
diff
) |
Newer revision →
(
diff
)
Jump to:
navigation
,
search
CALC FUNCTIONS
Date & Time Functions
FUNCTIONS
Today
Now
Year
Month
Day
Weekday
Hour
Minute
Second
Date
Datevalue
Time
Timevalue
Eomonth
Edate
Workday
Networkdays
Days
Days360
Daysinmonth
Daysinyear
Weeks
Weeksinyear
Weeknum
Weeknum_add
Months
Years
Isleapyear
Eastersunday
Yearfrac
< Previous Page
Next Page >
Contents
1
NOW
1.1
Syntax:
1.2
Example:
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 overview
Date & Time functions
Functions listed alphabetically
Functions listed by category
Category
:
Documentation/Reference/Calc/Date and Time functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Print/export
Create a book
Download as PDF
Printable version
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information