Documentation/How Tos/Calc: NOW function
From Apache OpenOffice Wiki
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.
-