The expression x=01Jan1904 sets x to zero, since the indicated date is the base date or “zero date” in JMP. If you examine the values of dates, they should be appropriately large numbers. For example 5oct1998 is 2990390400.
Converts the provided date to a string.
Section on Date-Time formats in the Scripting Guide.
Formats the number or expression x so that it shows as a date or duration when displayed in a text window. Values that represent one year or more are returned as dates. Values that represent less than a year are returned as durations.
Section on Date-Time formats in the Scripting Guide.
‒
|
"start" counts the number of times the interval starts.
|
‒
|
"actual" counts whole intervals.
|
‒
|
"fractional" counts fractional intervals.
|
A quoted string that contains the name of a datetime interval. For example, "Month", "Day" or "Hour".
‒
|
"start" truncates lesser field values.
|
‒
|
"actual" keeps the lesser field values.
|
‒
|
"fractional" honor fractional increment values.
|
Determine the day of the month supplied by the datetime argument.
Determine the day of the week supplied by the datetime argument.
Determine the day of the year supplied by the datetime argument.
Converts the value of x into the "format" that you specify in the second argument. Typically used for formatting datetime values from a number of seconds to a formatted date. Format choices are those shown in the data table column properties.
Any valid format, as a quoted string: "Best", "Fixed Decimal", "Percent", "PValue", "Scientific", "Currency", or any of the Date/Time formats.
An optional ISO 4217 code for a specific currency (for example, "GBP" for Great Britain, Pound). This argument is valid only if Currency is specified as format.
Determines the hour supplied by the datetime argument.
Returns a high precision time value (in microseconds). This function is only useful relative to another HP Time() value. The time value represents the number of microseconds since the start of the JMP session.
For less precise time values use Tick Seconds().
Returns the number of seconds per n days. Divide by this function to express seconds as days.
Parses a string of a given "format" and returns a date/time value. The value is expressed as if surrounded by the As Date() function, returning the date in "ddMonyyyy" format. Format choices are those shown in the data table column properties. See Utility Functions for details on As Date.
Returns the number of seconds per n hours. Divide by this function to express seconds as hours.
Returns the number of seconds per n minutes. Divide by this function to express seconds as minutes.
Returns the number of seconds per n weeks. Divide by this function to express seconds as weeks.
Returns the number of seconds per n years. Divide by this function to express seconds as years.
Returns a locale-specific string representation for the date supplied, formatted like "Sunday, February 29, 2004" or "Wednesday, November 9, 2011".
Determines the minute supplied by the datetime argument, 0-59.
Returns an integer representation for the month of the date supplied.
Returns the annual quarter of a datetime value as an integer 1-4.
Determines the second supplied by the datetime argument.
Returns a string representation for the date supplied, in the format mm/dd/yy. For example, "2/29/04" for the next Leap Day.
For higher time value resolution (for example, microseconds) use the HP Time() function.
Returns an integer representation for the time of day of the datetime supplied.