Vanguard Software
Forecasting & Planning Solutions
Home Products Solutions Services Customers Partners Company
 
Applying science to business management

contents.gifindex.gifprev1.gifnext1.gif

time

Format: time( style, sernum )

Arguments: (int) style Optional style specifier; default = 0

(time) sernum Optional date and time serial number; default = now

Returns: (text) Time implied by sernum in the specified format

Description: Time translates a date and time serial number into a text description of the implied time. If sernum is not supplied, the current date and time is assumed. The style specifier can be a value between 0 and 3 having the following meaning.

Style Description Example

   0 h:mm:ss tt 9:27:22 PM

   1 hh:mm:ss tt 09:27:22 PM

   2 H:mm:ss 21:27:22

   3 HH:mm:ss 21:27:22

The serial number used by all date and time primitives is the number of seconds that have elapsed between an arbitrary base date and the specified date and time. Dates before the year 1584 are not valid.

The serial numbers returned by the datenum and now primitives include the time unit of measure. Use formulas including the units years, months, days, hours, minutes, and sec to modify date serial numbers.

Examples: time = current time

time(0,now+3hours) = time 3 hours from now

See Also: datenum, now, date, year, month, day, hour, minute, second, weekday

  Demand Planning  |  Financial Forecasting
Forecasting Software  |  Strategic Planning Software  |  Decision Tree Software
Decision Support Software  |  Expert System Software  |  Online Surveys

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2011 Vanguard Software Corporation
Print this page   Email this page to a friend