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.
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.
"start" counts the number of times the interval starts.
"actual" counts whole intervals.
"fractional" counts fractional intervals.
"start" truncates lesser field values.
"actual" keeps the lesser field values.
"fractional" honor fractional increment values.
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.
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.
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".
Returns a string representation for the date supplied, formatted like "2/29/04 00:02:20".
Returns the annual quarter of a datetime value as an integer 1-4.
Returns a string representation for the date supplied, in the format mm/dd/yy. For example, "2/29/04" for the next Leap Day.