Date-Time Functions shows functions that convert seconds into date-time values and date-time values into seconds.
Abbrev Date(date)
Returns a string representation for the date supplied. The format is based on your computer’s regional setting. So for the English (United States) locale, the date is formatted like "02/29/2004". Even if you are running JMP in English with a different locale, the locale format is applied.
As Date(expression)
x = As Date( 8Dec2000 + In Days( 2 ) );
10Dec2000
As Date( 50000 );
:0:13:53:20
Date DMY(day, month, year)
Date MDY(month, day, year)
Day Of Week(date)
Day Of Year(date)
Day(date)
Format(date, "format")
Returns the value in the format specified in the second argument. Most typically used for formatting datetime values from a number of seconds to a formatted date. Format choices are those shown in the Column Info dialog box. Also see How JMP Interprets Two-Digit Years.
Hour(datetime)
In Days(n)
These functions return the number of seconds per n minutes, hours, days, weeks, or years. Divide by these functions to express an interval in seconds as an interval in other units.
In Hours(n)
In Minutes(n)
In Weeks(n)
In Years(n)
Long Date(date)
Returns a string representation for the specified date. The format is based on your computer’s regional setting. So for the English (United States) locale, the date is formatted like "Sunday, February 29, 2004". Even if you are running JMP in English with a different locale, the locale format is applied.
MDYHMS(date)
Returns a string representation for the date supplied, formatted like "2/29/2004 00:02:20 AM".
Minute(date-time)
Month(date)
Num(date-time)
InFormat(string, "format")
Parse Date(string, "format")
Parses a string of a given format and returns datetime value expressed as if surrounded by As Date(), returning the date in ddMonyyyy format.
Second(date-time)
Short Date(date)
Returns a string representation for the date supplied, in the format mm/dd/yyyy, regardless of locale (for example, "02/29/2004").
Time Of Day(date)
Today()
Week Of Year(date, <rule_n>)
Year(date)
For example, if today is May 19, 2011 and the time is 11:37:52 AM, Today() returns the number of seconds, and the functions that follow show that number of seconds since the base time in different date-time formats:
Today()
3388649872
Short Date( Today() );
"05/19/2011"
Long Date( Today() );
"Thursday, May 19, 2011"
Abbrev Date( Today() );
"5/19/2011"
MDYHMS( Today() );
"05/19/2011 11:37:52 AM"
Long Date( 3388649872 );
Long Date( 19May2011 );
"Thursday, May 19, 2011"
Note: Long Date() and Abbrev Date() values are formatted according to your computer’s regional settings.
You can extract parts of date values using the functions Month(), Day(), Year(), Day Of Week(), Day Of Year(), Week Of Year(), Time Of Day, Hour(), Minute(), and Second(), which all return integers. If today is May 24th, 2011, each of the following examples returns the 144th day of the year:
Day of Year( Today() );
Day of Year( 24May2011 );
Day of Year( Date MDY( 5, 24, 2011 ) );
144
A data table column named Date contains date-time values that are formatted as "m/d/y". You want to create a column that shows only the time. In the following script, the second column’s formula extracts the time of day from the Date value in the first column.
New Table( "Assembly Tests",
	Add Rows( 1 ),
	New Column( "Date",
		Numeric, Continuous,
		Format( "m/d/y" ),
		Set Values( [3389083557] )
	),
	New Column( "Time",
		Numeric, Continuous,
		Formula( Format( Time Of Day( :Date ), "h:m:s") )
	)
);
Example of Extracting the Time shows the result. Note that the time of day does not appear in the Date column, because the Format function applies the “m/d/y” format.
Example of Extracting the Time
Week of Year() returns the week of the year as a date-time value. Three rules determine when the first week of the year begins.
Week Of Year( Date DMY( 19, 6, 2013 ), 1 );
25
Week Of Year( Date DMY( 19, 6, 2013), 2 ) ;
24
Week Of Year( Date DMY( 19, 6, 2013 ), 3 );
25
The Date column in your data table shows when a customer uses his credit card to buy gas. You want to know how many days elapse between purchases. The following script creates a Days elapsed column. The formula in that column subtracts the Date value in the current row from that of the previous row.
New Table( "Gas Purchases",
	Add Rows( 3 ),
	New Column( "Date",
		Numeric,
		"Continuous",
		Format( "m/d/y" ),
		Set Values( [3392323200 3393532800 3394828800] )
	),
	New Column( "Days elapsed",
		Formula(
			If( Row() == 1,
				., // returns a missing value for the first row
				(:Date[Row()] - :Date[Row() - 1]) / In Days()
			)
		)
	)
);
Example of Calculating Date-Time Values
The In Minutes, In Hours, In Days, In Weeks, and In Years functions are used to express time intervals in units rather than seconds. Each of these functions returns the number of seconds associated with a particular period of time. For example, the following expression returns the number of weeks between now and July 4, 2012.
(Date DMY( 04, 07, 2012 ) - Today()) / In Weeks();
-208.225444775132
When the argument for the interval function is empty, JMP counts by 1. You can enter another number to change the count. For example, In Years(10) converts the interval to decades. The following expression returns the number of decades between now and December 31, 2037.
(Date DMY( 31, 12, 2037) - Today() ) / In Years( 10 );
2.18927583529799
Long Date( 25May11 );
"Wednesday, May 25, 2011"
Long Date( 25May1911 );
"Thursday, May 25, 1911"
How JMP Interprets Two-Digit Years explains how JMP interprets two-digit years.