Difference between revisions of "Documentation/How Tos/Calc: NOW function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
| Line 4: | Line 4: | ||
|ShowParttitle=block | |ShowParttitle=block | ||
|parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div style="font-size: 140%;">Date & Time Functions]] | |parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div style="font-size: 140%;">Date & Time Functions]] | ||
| − | |ShowNextPage=block | + | |
| − | |NextPage=Documentation/How_Tos/Calc: | + | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_YEAR_function |
| − | |ShowPrevPage=block | + | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_TODAY_function |
| − | |PrevPage=Documentation/How_Tos/Calc: | + | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Database_functions |
| − | |ShowPrevPart=block | + | |
| − | |PrevPart=Documentation/How_Tos/Calc:_Database_functions | + | |
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Financial_functions | |ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Financial_functions | ||
| + | |||
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
| − | * [[Documentation/How_Tos/Calc:_TODAY_function|<div style="font-size: 120% | + | * [[Documentation/How_Tos/Calc:_TODAY_function|<div style="font-size: 120%;">Today]] |
| − | * [[Documentation/How_Tos/Calc:_NOW_function|<div style="font-size: 120%;">Now]] | + | * [[Documentation/How_Tos/Calc:_NOW_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Now]] |
* [[Documentation/How_Tos/Calc:_YEAR_function|<div style="font-size: 120%;">Year]] | * [[Documentation/How_Tos/Calc:_YEAR_function|<div style="font-size: 120%;">Year]] | ||
* [[Documentation/How_Tos/Calc:_MONTH_function|<div style="font-size: 120%;">Month]] | * [[Documentation/How_Tos/Calc:_MONTH_function|<div style="font-size: 120%;">Month]] | ||
Revision as of 14:25, 12 May 2013
CALC FUNCTIONS
- Date & Time Functions
- TodayNowYearMonthDayWeekdayHourMinuteSecond
- Date
DatevalueTimeTimevalueEomonthEdateWorkdayNetworkdaysDaysDays360DaysinmonthDaysinyearWeeksWeeksinyearWeeknumWeeknum_addMonthsYears
Contents
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.
-
