$DateDif - Revision history

ELowell: /* Usage */

2018-10-19T20:59:47Z

Usage

← Older revision		Revision as of 20:59, 19 October 2018
Line 77:		Line 77:
	In the following procedure, <code>Date_Difference</code>, <var>$Datedif</var> calculates the difference between dates twice. Before the first <var>Print</var> statement, the <var>[[CUSTOM parameter\|CUSTOM]]</var> parameter is set to 1, so the century defaults to the current century. Before the second <var>Print</var> statement, the <var>DEFCENT</var> parameter is set to 20. </p>		In the following procedure, <code>Date_Difference</code>, <var>$Datedif</var> calculates the difference between dates twice. Before the first <var>Print</var> statement, the <var>[[CUSTOM parameter\|CUSTOM]]</var> parameter is set to 1, so the century defaults to the current century. Before the second <var>Print</var> statement, the <var>DEFCENT</var> parameter is set to 20. </p>
	<p class="code">PROCEDURE DATE_DIFFERENCE		<p class="code">PROCEDURE DATE_DIFFERENCE
	RESET CUSTOM=(1)		RESET CUSTOM=1
	Begin		Begin
	Print $Datedif('CYYDDD','96333','YY MM DD','97 06 22',%defcent,%centsplt)		Print $Datedif('CYYDDD','96333','YY MM DD','97 06 22',%defcent,%centsplt)

JAL: misc cleanup

2015-10-06T19:17:39Z

misc cleanup

← Older revision		Revision as of 19:17, 6 October 2015
Line 5:		Line 5:
	<p>		<p>
	The format of the <var>$DateDif</var> function is:</p>		The format of the <var>$DateDif</var> function is:</p>
	<p class="syntax">$~~Datedif~~(<span class="term">date-1-format</span>, <span class="term">date-1</span>, <span class="term">date-2-format</span>, <span class="term">date-2</span>, [<span class="term">defcent</span>], [<span class="term">centsplt</span>])</p>		<p class="syntax">$DateDif(<span class="term">date-1-format</span>, <span class="term">date-1</span>, <span class="term">date-2-format</span>, <span class="term">date-2</span>, [<span class="term">defcent</span>], [<span class="term">centsplt</span>])</p>
	<p>		<p>
	Where:</p>		Where:</p>
Line 48:		Line 48:
	<tr>		<tr>
	<th>CYY</th>		<th>CYY</th>
	<td>The century, plus the year. Century (C) is a single digit, where 0 represents 1900, 1 represents 2000, and so on.</td></tr>		<td>The century, plus the year. Century (<var>C</var>) is a single digit, where 0 represents 1900, 1 represents 2000, and so on.</td></tr>
	</table>		</table>
	<p>		<p>
Line 69:		Line 69:
	<li>The <var class="term">defcent</var> argument (optional) specifies the <var>[[DEFCENT parameter\|DEFCENT]]</var> value to use; it overrides all other <var>DEFCENT</var> and <var>[[CENTSPLT parameter\|CENTSPLT]]</var> parameter values. This argument cannot be specified with the <var class="term">centsplt</var> argument, unless one of the values is NULL.</li>		<li>The <var class="term">defcent</var> argument (optional) specifies the <var>[[DEFCENT parameter\|DEFCENT]]</var> value to use; it overrides all other <var>DEFCENT</var> and <var>[[CENTSPLT parameter\|CENTSPLT]]</var> parameter values. This argument cannot be specified with the <var class="term">centsplt</var> argument, unless one of the values is NULL.</li>

	<li>The <var class="term">centsplt</var> argument (optional) specifies the ~~CENTSPLIT~~ value to use; it overrides all other <var>DEFCENT</var> and <var>CENTSPLT</var> parameter values. This argument cannot be specified with the <var class="term">defcent</var> argument, unless one of the values is NULL.</li>		<li>The <var class="term">centsplt</var> argument (optional) specifies the <var>CENTSPLT</var> value to use; it overrides all other <var>DEFCENT</var> and <var>CENTSPLT</var> parameter values. This argument cannot be specified with the <var class="term">defcent</var> argument, unless one of the values is NULL.</li>
	</ul>		</ul>

Line 97:		Line 97:
	</ul>		</ul>

	====How $~~Datedif~~ works====		====How $DateDif works====
	<ul>		<ul>
	<li>If date1 is the same as ~~date2~~, 0 is returned.</li>		<li>If <var class="term">date1</var> is the same as <var class="term">date21</var>, 0 is returned.</li>

	<li>If date1 is earlier than date2, a negative integer is returned.</li>		<li>If <var class="term">date1</var> is earlier than <var class="term">date2</var>, a negative integer is returned.</li>

	<li>If date1 is later than date2, a positive integer is returned.</li>		<li>If <var class="term">date1</var> is later than <var class="term">date2</var>, a positive integer is returned.</li>

	<li>If an error occurs, 99999999 is returned. </li>		<li>If an error occurs, <code>99999999</code> is returned. </li>
	</ul>		</ul>

JAL: more conversion cleanup

2015-09-23T22:21:39Z

more conversion cleanup

← Older revision		Revision as of 22:21, 23 September 2015
Line 4:		Line 4:
	==Syntax==		==Syntax==
	<p>		<p>
	The format of the <var>$~~Datedif~~</var> function is:</p>		The format of the <var>$DateDif</var> function is:</p>
	<p class="syntax">$Datedif(<span class="term">date-1-format</span>, <span class="term">date-1</span>, <span class="term">date-2-format</span>, <span class="term">date-2</span>, <span class="term">defcent</span>, <span class="term">centsplt</span>)</p>		<p class="syntax">$Datedif(<span class="term">date-1-format</span>, <span class="term">date-1</span>, <span class="term">date-2-format</span>, <span class="term">date-2</span>, [<span class="term">defcent</span>], [<span class="term">centsplt</span>])</p>
	<p>		<p>
	Where:</p>		Where:</p>
	<ul>		<ul>
	<li><var class="term">date-1-format</var> specifies the format of the first date. The format can be a combination of these elements:		<li><var class="term">date-1-format</var> specifies the format of the first date. The format can be a combination of these elements:
	<table>		<table class="thJustBold">
	<tr>		<tr>
	<td>DD</td>		<th>DD</th>
	<td>Gregorian numeric day</td>		<td>Gregorian numeric day</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>DDD</td>		<th>DDD</th>
	<td>Julian numeric date</td>		<td>Julian numeric date</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>MM</td>		<th>MM</th>
	<td>Numeric month</td>		<td>Numeric month</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>MON</td>		<th>MON</th>
	<td>Abbreviated month name</td>		<td>Abbreviated month name</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>MONTH</td>		<th>MONTH</th>
	<td>Full month name</td>		<td>Full month name</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>YY</td>		<th>YY</th>
	<td>Last two digits of numeric year (assumes that the year prefix is 19)</td>		<td>Last two digits of numeric year (assumes that the year prefix is 19)</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>YYYY</td>		<th>YYYY</th>
	<td>Full numeric year </td>		<td>Full numeric year </td>
	</tr>		</tr>

	<tr>		<tr>
	<td>CYY</td>		<th>CYY</th>
	<td>The century, plus the year. Century (C) is a single digit, where 0 represents 1900, 1 represents 2000, and so on.</td>		<td>The century, plus the year. Century (C) is a single digit, where 0 represents 1900, 1 represents 2000, and so on.</td></tr>
	</tr>
	</table>		</table>
	<p>		<p>
Line 55:		Line 54:
	<ul>		<ul>
	<li>A format that has a month, day, and year element</li>		<li>A format that has a month, day, and year element</li>
	<li>A Julian date format that has a year element and a day element in the format DDD </li>		<li>A Julian date format that has a year element and a day element in the format <var>DDD</var> </li>
	</ul>		</ul>
	<p>		<p>
Line 65:		Line 64:

	<li><var class="term">date-2-format</var> specifies the format of the second date. The format requirements are the same as those for the <var class="term">date-1-format</var> argument. This argument can be omitted but the comma after it is required. If this argument is omitted, <var>$Datedif</var> assumes that <var class="term">date-2</var> is in the same format as <var class="term">date-1</var>. </li>		<li><var class="term">date-2-format</var> specifies the format of the second date. The format requirements are the same as those for the <var class="term">date-1-format</var> argument. This argument can be omitted but the comma after it is required. If this argument is omitted, <var>$Datedif</var> assumes that <var class="term">date-2</var> is in the same format as <var class="term">date-1</var>. </li>
	~~</li>~~

	<li><var class="term">date-2</var> specifies the second date. The date must be either in the format specified in the <var class="term">date-2-format</var> argument, or in the format specified in <var class="term">date-1-format</var> if <var class="term">date-2-format</var> is not specified. The date can be as many as 36 characters in length.</li>		<li><var class="term">date-2</var> specifies the second date. The date must be either in the format specified in the <var class="term">date-2-format</var> argument, or in the format specified in <var class="term">date-1-format</var> if <var class="term">date-2-format</var> is not specified. The date can be as many as 36 characters in length.</li>
	~~</li>~~

	<li>The <var class="term">defcent</var> argument (optional) specifies the <var>[[DEFCENT parameter\|DEFCENT]]</var> value to use; it overrides all other <var>DEFCENT</var> and <var>[[CENTSPLT parameter\|CENTSPLT]]</var> parameter values. This argument cannot be specified with the <var class="term">centsplt</var> argument, unless one of the values is NULL.</li>		<li>The <var class="term">defcent</var> argument (optional) specifies the <var>[[DEFCENT parameter\|DEFCENT]]</var> value to use; it overrides all other <var>DEFCENT</var> and <var>[[CENTSPLT parameter\|CENTSPLT]]</var> parameter values. This argument cannot be specified with the <var class="term">centsplt</var> argument, unless one of the values is NULL.</li>
	~~</li>~~

	<li>The <var class="term">centsplt</var> argument (optional) specifies the CENTSPLIT value to use; it overrides all other <var>DEFCENT</var> and <var>CENTSPLT</var> parameter values. This argument cannot be specified with the <var class="term">defcent</var> argument, unless one of the values is NULL.</li>		<li>The <var class="term">centsplt</var> argument (optional) specifies the CENTSPLIT value to use; it overrides all other <var>DEFCENT</var> and <var>CENTSPLT</var> parameter values. This argument cannot be specified with the <var class="term">defcent</var> argument, unless one of the values is NULL.</li>
Line 92:		Line 88:
	====Separators and leading zeros====		====Separators and leading zeros====
	<ul>		<ul>
	<li>The separators in each format must match the separators in the corresponding date. For example:~~</li>~~		<li>The separators in each format must match the separators in the corresponding date. For example:
	<p class="code">$datedif('MON DD, YYYY','JAN 08, 1990','YY:DDD', '88:210')		<p class="code">$datedif('MON DD, YYYY','JAN 08, 1990','YY:DDD', '88:210')
	</p></li>		</p></li>

	<li>When necessary, pad the month or date in the date argument with leading zeros to match the length of corresponding format argument. For example:~~</li>~~		<li>When necessary, pad the month or date in the date argument with leading zeros to match the length of corresponding format argument. For example:
	<p class="code">$datedif('YY DDD','90 034',,'90 007')		<p class="code">$datedif('YY DDD','90 034',,'90 007')
	</p></li>		</p></li>
Line 104:		Line 100:
	<ul>		<ul>
	<li>If date1 is the same as date2, 0 is returned.</li>		<li>If date1 is the same as date2, 0 is returned.</li>
	~~</li>~~
	<li>If date1 is earlier than date2, a negative integer is returned.</li>		<li>If date1 is earlier than date2, a negative integer is returned.</li>
	~~</li>~~
	<li>If date1 is later than date2, a positive integer is returned.</li>		<li>If date1 is later than date2, a positive integer is returned.</li>
	~~</li>~~
	<li>If an error occurs, 99999999 is returned. </li>		<li>If an error occurs, 99999999 is returned. </li>
	~~</li>~~
	</ul>		</ul>

Line 119:		Line 114:
	<p>		<p>
	prints this value:</p>		prints this value:</p>
	<p class="~~code~~"~~><b></b~~>-456		<p class="output">-456
	</p>		</p>

	[[Category:SOUL $functions]]		[[Category:SOUL $functions]]

Tbullock: Just eight nines.

2014-12-10T20:52:38Z

Just eight nines.

← Older revision		Revision as of 20:52, 10 December 2014
Line 109:		Line 109:
	<li>If date1 is later than date2, a positive integer is returned.</li>		<li>If date1 is later than date2, a positive integer is returned.</li>
	</li>		</li>
	<li>If an error occurs, ~~999999999~~ is returned. </li>		<li>If an error occurs, 99999999 is returned. </li>
	</li>		</li>
	</ul>		</ul>

Mlarocca: Mlarocca moved page $DATEDIF to $DateDif: Lower case change

2014-07-17T13:03:22Z

Mlarocca moved page $DATEDIF to $DateDif: Lower case change

← Older revision	Revision as of 13:03, 17 July 2014
(No difference)

JAL at 22:15, 3 April 2014

2014-04-03T22:15:30Z

← Older revision		Revision as of 22:15, 3 April 2014
Line 2:		Line 2:
	The <var>$Datedif</var> function returns the difference in days between two dates. </p>		The <var>$Datedif</var> function returns the difference in days between two dates. </p>

	====Syntax====		==Syntax==
	<p>		<p>
	The format of the <var>$Datedif</var> function is:</p>		The format of the <var>$Datedif</var> function is:</p>
Line 76:		Line 76:
	</ul>		</ul>

			==Usage==
	====Dates in differing centuries====		====Dates in differing centuries====
	<p>		<p>

JAL: minor cleanup

2014-04-03T22:10:02Z

minor cleanup

Show changes

Tbullock: Deleted PROCEDURE DATE_DIFFERENCE ... END PROCEDURE Add right parentheses

2014-04-03T17:44:01Z

Deleted PROCEDURE DATE_DIFFERENCE ... END PROCEDURE Add right parentheses

← Older revision		Revision as of 17:44, 3 April 2014
Line 60:		Line 60:
	<b>Dates in differing centuries</b>		<b>Dates in differing centuries</b>
	<p>In the following procedure Date_Difference, the $DATEDIF function calculates the difference between dates twice. Before the first PRINT command, the CUSTOM parameter is set to 1, so the century defaults to the current century. Before the second PRINT command, the DEFCENT parameter is set to 20. </p>		<p>In the following procedure Date_Difference, the $DATEDIF function calculates the difference between dates twice. Before the first PRINT command, the CUSTOM parameter is set to 1, so the century defaults to the current century. Before the second PRINT command, the DEFCENT parameter is set to 20. </p>
	<p class="code">~~PROCEDURE DATE_DIFFERENCE~~		<p class="code">
	RESET CUSTOM =(1		RESET CUSTOM=(1)

	BEGIN		BEGIN
	PRINT $DATEDIF('CYYDDD','96333','YY MM DD','97 06 22',-		PRINT $DATEDIF('CYYDDD','96333','YY MM DD','97 06 22',-
Line 70:		Line 69:
	%DEFCENT,%CENTSPLT)		%DEFCENT,%CENTSPLT)
	END		END
	~~</p>~~
	~~<p class="code">END PROCEDURE~~
	</p>		</p>
	<p>For an explanation of the DEFCENT and CENTSPLT parameters processing see Rocket <var class="product">Model 204</var> Parameter and Command Reference Manual in the chapter on parameters.</p>		<p>For an explanation of the DEFCENT and CENTSPLT parameters processing see Rocket <var class="product">Model 204</var> Parameter and Command Reference Manual in the chapter on parameters.</p>

Tbullock: Added left parentheses

2014-04-03T17:38:46Z

Added left parentheses

← Older revision		Revision as of 17:38, 3 April 2014
Line 2:		Line 2:
	<b>Syntax</b>		<b>Syntax</b>
	<p>The format of the $DATEDIF function is:</p>		<p>The format of the $DATEDIF function is:</p>
	<p class="code">$DATEDIF date-1-format,date-1,date-2-format,date-2,		<p class="code">$DATEDIF(date-1-format,date-1,date-2-format,date-2,defcent,centsplt)</p>

	defcent,centsplt)
	</p>
	<p>where:</p>		<p>where:</p>
	<ul>		<ul>

Alex: Automatically generated page update

2013-04-20T13:18:46Z

Automatically generated page update

New page

The $DATEDIF function returns the difference in days between the two dates. 
Syntax
The format of the $DATEDIF function is:
$DATEDIF date-1-format,date-1,date-2-format,date-2,

defcent,centsplt)

where:
<ul>
<li>Date-1-format specifies the format of the first date. The format can be a combination of these elements: </li>
<table>
<tr>
<td>DD</td>
<td>Gregorian numeric day</td>
</tr>
<tr>
<td>DDD</td>
<td>Julian numeric date</td>
</tr>
<tr>
<td>MM</td>
<td>Numeric month</td>
</tr>
<tr>
<td>MON</td>
<td>Abbreviated month name</td>
</tr>
<tr>
<td>MONTH</td>
<td>Full month name</td>
</tr>
<tr>
<td>YY</td>
<td>Last two digits of numeric year (assumes that the year prefix is 19)</td>
</tr>
<tr>
<td>YYYY</td>
<td>Full numeric year </td>
</tr>
<tr>
<td>CYY</td>
<td>The century, plus the year. Century (C) is a single digit, where 0 represents 1900, 1 represents 2000, and so on.</td>
</tr>
</table>
Valid formats are:
</li>
</ul>
A format that has a month, day, and year element
A Julian date format that has a year element and a day element in the format DDD 
Any EBCDIC characters except single quotes are allowed within the input format and appear unchanged in the output date. The input format can be as many as 32 characters in length. 
<ul>
<li>Date-1 specifies the first date in the format specified by the date-1-format argument. The date can be as many as 36 characters in length. </li>
</li>
<li>Date-2-format specifies the format of the second date. The format requirements are the same as those for the date-1-format argument. This argument can be omitted but the comma after it is required. If this argument is omitted, $DATEDIF assumes that date-2 is in the same format as date-1. </li>
</li>
<li>Date-2 specifies the second date. The date must be either in the format specified in the date-2-format argument, or in the format specified in date-1-format if date-2-format is not specified. The date can be as many as 36 characters in length.</li>
</li>
<li>The defcent argument (optional) specifies the DEFCENT value to use; it overrides all other DEFCENT and CENTSPLT parameter values. This argument cannot be specified with the centsplt argument, unless one of the values is NULL.</li>
</li>
<li>The centsplt argument (optional) specifies the CENTSPLIT value to use; it overrides all other DEFCENT and CENTSPLT parameter values. This argument cannot be specified with the defcent argument, unless one of the values is NULL.</li>
</li>
</ul>
Dates in differing centuries
In the following procedure Date_Difference, the $DATEDIF function calculates the difference between dates twice. Before the first PRINT command, the CUSTOM parameter is set to 1, so the century defaults to the current century. Before the second PRINT command, the DEFCENT parameter is set to 20. 
PROCEDURE DATE_DIFFERENCE
RESET CUSTOM =(1

BEGIN
PRINT $DATEDIF('CYYDDD','96333','YY MM DD','97 06 22',-
%DEFCENT,%CENTSPLT)
%DEFCENT = 20
PRINT $DATEDIF('CYYDDD','096333','YY MM DD','97 06 22',-
%DEFCENT,%CENTSPLT)
END

END PROCEDURE

For an explanation of the DEFCENT and CENTSPLT parameters processing see Rocket <var class="product">Model 204</var> Parameter and Command Reference Manual in the chapter on parameters.
Separators and leading zeros
<ul>
<li>The separators in each format must match the separators in the corresponding date. For example:</li>
$DATEDIF('MON DD, YYYY','JAN 08, 1990', -
'YY:DDD', '88:210')
</li>
<li>When necessary, pad the month or date in the date argument with leading zeros to match the length of corresponding format argument. For example:</li>
$DATEDIF('YY DDD','90 034',,'90 007')
</li>
</ul>
How $DATEDIF works
<ul>
<li>If date1 is the same as date2, 0 is returned.</li>
</li>
<li>If date1 is earlier than date2, a negative integer is returned.</li>
</li>
<li>If date1 is later than date2, a positive integer is returned.</li>
</li>
<li>If an error occurs, 999999999 is returned. </li>
</li>
</ul>
Example
PRINT $DATEDIF('MMDDYY','010790',,'040891')

prints this value:
-456

[[Category:SOUL $functions]]