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 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.
Informat( "07152000", "MMDDYYYY" );
15Jul2000
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.