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.
Abbrev Date( 29Feb2004 );
02/29/2004
Date-Time Functions and 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.
Date-Time Functions and Formats in the Scripting Guide.
"start" includes full or partial intervals.
"actual" counts only whole intervals.
"fractional" returns fractional differences using averages for "Year", "Quarter", and "Month" intervals.
A quoted string that contains the name of a datetime interval. "Year", "Quarter", "Month", "Week", "Day", "Hour", "Minute", and "Second" are supported.
"start" truncates the date to the nearest interval prior to adding the increment. For example, it removes the time and outputs the date. "start" is the default value.
"actual" retains the full input datetime value.
"fractional" allows fractional incremental values using averages for the duration of "Year", "Quarter", and "Month" intervals.
d1 = Date DMY( 12, 2, 2003 );
3127852800
 
Day( 3127852800 );
12
Day( d1 );
12
Converts the value x into the "format" that you specify in the subsequent arguments.
See Numeric Formats in the Using JMP book for details about the arguments. The arguments are also shown in the data table Column Info window.
Format( x, 10, 2, "Use thousands separator");
Format( x, "Currency", "EUR", 20, <<Use Locale(0)); // ignores computer locale
Format( x, "m/d/y", 10 );
Format( x, "Precision", 10, 2, "Keep trailing zeroes", "Keep all whole digits" );
Format( x, "Latitude DDD", "PUNDIR"); // "PUN" for punctuation, "DIR" for direction, PUNDIR for both
Format( x, "Custom", Formula( Abs( value ) ), 15 );
Converts the value of x into the "format" that you specify in the second argument. Format choices are those shown in the data table column properties.
See Numeric Formats in the Using JMP book for details about the arguments.
Format Date( Today(), "yyyQq" );
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.
Informat( "07152000", "MMDDYYYY" );
15Jul2000
See Change Date-Time Input and Display Formats in the Scripting Guide for more examples.
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.

Help created on 7/12/2018