$DateChg - Revision history

JAL: misc cleanup

2015-09-24T20:36:45Z

misc cleanup

← Older revision		Revision as of 20:36, 24 September 2015
Line 1:		Line 1:
	<p>The $DateChg function adds or subtracts a specified number of days from a given date. The result is returned in the format of the input date.</p>		<p>
	~~<b>~~Syntax~~</b>~~		The <var>$DateChg</var> function adds or subtracts a specified number of days from a given date. The result is returned in the format of the input date.</p>
	<p>The format of the $DateChg function is:</p>
	<p class="~~code~~">$DateChg(format, date, number of days)		==Syntax==
			<p>
			The format of the <var>$DateChg</var> function is:</p>
			<p class="syntax">$DateChg(<span class="term">format, date, number-of-days</span>)
	</p>		</p>
	<p>~~where~~:</p>		<p>Where:</p>
	<ul>		<ul>
	<li>format specifies the format of the input date. The format can be a combination of these elements:~~</li>~~		<li><var class="term">format</var> specifies the format of the input date. The format can be a combination of these elements:
	<table>		<table class="thJustBold">
	<tr>		<tr><th>DD</th>
	<td>DD</td>		<td>Gregorian numeric day</td></tr>
	<td>Gregorian numeric day</td>
	</tr>		<tr><th>DDD</th>
	<tr>		<td>Julian numeric date</td></tr>
	<td>DDD</td>
	<td>Julian numeric date</td>		<tr><th>MM</th>
	</tr>		<td>Numeric month</td></tr>
	<tr>
	<td>MM</td>		<tr><th>MON</th>
	<td>Numeric month</td>		<td>Abbreviated month name</td></tr>
	</tr>
	<tr>		<tr><th>MONTH</th>
	<td>MON</td>		<td>Full month name</td></tr>
	<td>Abbreviated month name</td>
	</tr>		<tr><th>YY</th>
	<tr>		<td>Last two digits of numeric year (assumes that the year prefix is 19)</td></tr>
	<td>MONTH</td>
	<td>Full month name</td>		<tr><th>YYYY</th>
	</tr>		<td>Full numeric year </td></tr>
	<tr>
	<td>YY</td>		<tr><th>CYY</th>
	<td>Last two digits of numeric year (assumes that the year prefix is 19)</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>
	<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>		</table>
	<p>Valid formats are:~~</p>~~		<p>
	~~</li>~~		Valid formats are:</p>
	~~</ul>~~
	~~<p>A format that has a month, day, and year element</p>~~
	~~<p>A Julian date format that has a year element and a day element in the format DDD </p>~~
	~~<p>Any EBCDIC characters except single quotes are allowed within the format. The format can be as many as 32 characters in length.~~ </p>
	<ul>		<ul>
	<li>date specifies a date in the format indicated by the format argument. The date can be as many as 36 characters in length. </li>		<li>A format that has a month, day, and year element</li>
	</li>
	<li>number of days indicates the number of days to be added or deducted from the date. The number must be an integer. ~~</li>~~		<li>A Julian date format that has a year element and a day element in the format <var>DDD</var> </li>
	</li>
			<li>Any EBCDIC characters except single quotes are allowed within the format. The format can be as many as 32 characters in length. </li>
			</ul></li>

			<li><var class="term">date</var> specifies a date in the format indicated by the format argument. The date can be as many as 36 characters in length. </li>

			<li><var class="term">number-of-days</var> indicates the number of days to be added or deducted from the date. The number must be an integer. </li>
	</ul>		</ul>
	~~<b>~~Separators and leading zeros~~</b>~~
			===Separators and leading zeros===
	<ul>		<ul>
	<li>The separators in the format argument must match the separators in the date argument. For example:~~</li>~~		<li>The separators in the format argument must match the separators in the date argument. For example:
	<p class="code">$datechg('MONTH - DD - YYYY','JANUARY - 05 - ~~1986~~', 20)		<p class="code">$datechg('MONTH - DD - YYYY','JANUARY - 05 - 1996', 20)
	</p></li>		</p></li>

	<li>When necessary, you must pad the month or date in the date argument with leading zeros to match the length of the format. For example:</li>		<li>When necessary, you must pad the month or date in the date argument with leading zeros to match the length of the format. For example:</li>
	<p class="code">$datechg('YY DDD','86 023',22)		<p class="code">$datechg('YY DDD','96 023',22)
	</p></li>		</p></li>
	</ul>		</ul>
	~~<b>~~How $DateChg works~~</b>~~
			==How $DateChg works==
	<ul>		<ul>
	<li>If the number of days is a positive integer, the number is added to the date.</li>		<li>If the number of days is a positive integer, the number is added to the date.</li>
	~~</li>~~
	<li>If number of days is a negative integer, the number is deducted from the date.</li>		<li>If number of days is a negative integer, the number is deducted from the date.</li>
	~~</li>~~
	<li>If an error occurs, all asterisks (*) are returned. ~~</li>~~		<li>If an error occurs, all asterisks (<tt>*</tt>) are returned. </li>
	</li>
	</ul>		</ul>
	~~<b>~~Example~~</b>~~
	<p class="code">~~PRINT~~ $datechg('MON. DD, YYYY','JAN. 10, ~~1999~~', 15)		==Example==
			The following statement:
			<p class="code">Print $datechg('MON. DD, YYYY','JAN. 10, 2009', 15)
	</p>		</p>
	<p>~~prints~~ this value:</p>		<p>
	<p class="~~code~~">JAN. 25, ~~1999~~		Prints this value:</p>
			<p class="output">JAN. 25, 2009
	</p>		</p>

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

Mlarocca at 14:26, 16 July 2014

2014-07-16T14:26:18Z

← Older revision		Revision as of 14:26, 16 July 2014
Line 1:		Line 1:
	<p>The $~~DATECHG~~ function adds or subtracts a specified number of days from a given date. The result is returned in the format of the input date.</p>		<p>The $DateChg function adds or subtracts a specified number of days from a given date. The result is returned in the format of the input date.</p>
	<b>Syntax</b>		<b>Syntax</b>
	<p>The format of the $~~DATECHG~~ function is:</p>		<p>The format of the $DateChg function is:</p>
	<p class="code">$~~DATECHG~~(format, date, number of days)		<p class="code">$DateChg(format, date, number of days)
	</p>		</p>
	<p>where:</p>		<p>where:</p>
Line 56:		Line 56:
	<ul>		<ul>
	<li>The separators in the format argument must match the separators in the date argument. For example:</li>		<li>The separators in the format argument must match the separators in the date argument. For example:</li>
	<p class="code">$~~DATECHG~~('MONTH - DD - YYYY','JANUARY - 05 - 1986', 20)		<p class="code">$datechg('MONTH - DD - YYYY','JANUARY - 05 - 1986', 20)
	</p></li>		</p></li>
	<li>When necessary, you must pad the month or date in the date argument with leading zeros to match the length of the format. For example:</li>		<li>When necessary, you must pad the month or date in the date argument with leading zeros to match the length of the format. For example:</li>
	<p class="code">$~~DATECHG~~('YY DDD','86 023',22)		<p class="code">$datechg('YY DDD','86 023',22)
	</p></li>		</p></li>
	</ul>		</ul>
	<b>How $~~DATECHG~~ works</b>		<b>How $DateChg works</b>
	<ul>		<ul>
	<li>If the number of days is a positive integer, the number is added to the date.</li>		<li>If the number of days is a positive integer, the number is added to the date.</li>
Line 72:		Line 72:
	</ul>		</ul>
	<b>Example</b>		<b>Example</b>
	<p class="code">PRINT $~~DATECHG~~('MON. DD, YYYY','JAN. 10, 1999', 15)		<p class="code">PRINT $datechg('MON. DD, YYYY','JAN. 10, 1999', 15)
	</p>		</p>
	<p>prints this value:</p>		<p>prints this value:</p>

Mlarocca: Mlarocca moved page $DATECHG to $DateChg: Lower case change

2014-07-16T14:24:20Z

Mlarocca moved page $DATECHG to $DateChg: Lower case change

← Older revision	Revision as of 14:24, 16 July 2014
(No difference)

Alex: Automatically generated page update

2013-04-20T13:18:43Z

Automatically generated page update

New page

The $DATECHG function adds or subtracts a specified number of days from a given date. The result is returned in the format of the input date.
Syntax
The format of the $DATECHG function is:
$DATECHG(format, date, number of days)

where:
<ul>
<li>format specifies the format of the input 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 format. The format can be as many as 32 characters in length. 
<ul>
<li>date specifies a date in the format indicated by the format argument. The date can be as many as 36 characters in length. </li>
</li>
<li>number of days indicates the number of days to be added or deducted from the date. The number must be an integer. </li>
</li>
</ul>
Separators and leading zeros
<ul>
<li>The separators in the format argument must match the separators in the date argument. For example:</li>
$DATECHG('MONTH - DD - YYYY','JANUARY - 05 - 1986', 20)
</li>
<li>When necessary, you must pad the month or date in the date argument with leading zeros to match the length of the format. For example:</li>
$DATECHG('YY DDD','86 023',22)
</li>
</ul>
How $DATECHG works
<ul>
<li>If the number of days is a positive integer, the number is added to the date.</li>
</li>
<li>If number of days is a negative integer, the number is deducted from the date.</li>
</li>
<li>If an error occurs, all asterisks (*) are returned. </li>
</li>
</ul>
Example
PRINT $DATECHG('MON. DD, YYYY','JAN. 10, 1999', 15)

prints this value:
JAN. 25, 1999

[[Category:SOUL $functions]]