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
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information