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.
|
Determine the day of the month supplied by the datetime argument.
d1 = Date DMY( 12, 2, 2003 );
3127852800
Day( 3127852800 );
12
Day( d1 );
12
Determine the day of the week supplied by the datetime argument.
Determine the day of the year supplied by the datetime argument.
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.
Format Date( Today(), "yyyQq" );
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.
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".
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.