$Sir ND2Date: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(Automatically generated page update) |
||
| (23 intermediate revisions by 4 users not shown) | |||
| Line 2: | Line 2: | ||
<span class="pageSubtitle">Convert datetime number of days to string</span> | <span class="pageSubtitle">Convert datetime number of days to string</span> | ||
<p class=" | <p class="warn"><b>Note: </b>Many $functions have been deprecated in favor of Object Oriented methods. The OO equivalent for this $function is <var>[[DaysToString (Float function)|DaysToString]]</var>.</p> | ||
The <var>$Sir_ND2Date</var> function expects a numeric datetime argument containing a number of days since January 1, 1900, and a datetime format string. It returns the date represented by the first argument, in the format corresponding to the second argument. <var>$Sir_ND2Date</var> accepts an optional error control string and returns the null string if an error is detected. | The <var>$Sir_ND2Date</var> function expects a numeric datetime argument containing a number of days since January 1, 1900, and a datetime format string. It returns the date represented by the first argument, in the format corresponding to the second argument. <var>$Sir_ND2Date</var> accepts an optional error control string and returns the null string if an error is detected. | ||
==Syntax== | ==Syntax== | ||
<p class="syntax">< | <p class="syntax"><span class="term">%dat</span> <span class="literal">= $Sir_ND2Date(</span><span class="term">datn</span><span class="literal">,</span> <span class="term">fmt</span><span class="literal">,</span> <span class="term">errctl</span><span class="literal">)</span> | ||
< | </p> | ||
===Syntax terms=== | ===Syntax terms=== | ||
<table class="syntaxTable"> | <table class="syntaxTable"> | ||
<tr><th>%dat</th> | |||
<td>Set to the datetime value string, using format specified by <var class="term">fmt</var>, corresponding to <var class="term">datn</var>, unless an error is detected. | |||
</td></tr> | |||
<tr><th>datn</th> | <tr><th>datn</th> | ||
<td>Datetime number containing a signed number of days since January 1, 1900.</td></tr> | <td>Datetime number containing a signed number of days since January 1, 1900.</td></tr> | ||
| Line 18: | Line 21: | ||
<tr><th>errctl</th> | <tr><th>errctl</th> | ||
<td>Optional error control string; refer to [[Datetime string formats#Datetime error handling|"Datetime error handling"]].</td></tr> | <td>Optional error control string; refer to [[Datetime string formats#Datetime error handling|"Datetime error handling"]].</td></tr> | ||
</table> | </table> | ||
| Line 42: | Line 42: | ||
==Products authorizing {{PAGENAMEE}}== | |||
<ul class="smallAndTightList"> | <ul class="smallAndTightList"> | ||
<li>[[Sirius functions]]</li> | <li>[[List of $functions|Sirius functions]]</li> | ||
<li>[[Fast/Unload User Language Interface]]</li> | <li>[[Fast/Unload User Language Interface]]</li> | ||
<li>[[Janus Open Client]]</li> | <li>[[Media:JoclrNew.pdf|Janus Open Client]]</li> | ||
<li>[[Janus Open Server]]</li> | <li>[[Media:JosrvrNew.pdf|Janus Open Server]]</li> | ||
<li>[[Janus Sockets]]</li> | <li>[[Janus Sockets]]</li> | ||
<li>[[Janus Web Server]]</li> | <li>[[Janus Web Server]]</li> | ||
<li> | <li>Japanese functions</li> | ||
<li>[[Sir2000 Field Migration Facility]]</li> | <li>[[Media:SirfieldNew.pdf|Sir2000 Field Migration Facility]]</li> | ||
<li>[ | <li>[http://m204wiki.rocketsoftware.com/images/d/d6/Ul2krNew.pdf Sir2000 User Language Tools]</li> | ||
</ul> | </ul> | ||
[[Category:$Functions|$Sir_ND2Date]] | [[Category:$Functions|$Sir_ND2Date]] | ||
Latest revision as of 23:27, 20 September 2018
Convert datetime number of days to string
Note: Many $functions have been deprecated in favor of Object Oriented methods. The OO equivalent for this $function is DaysToString.
The $Sir_ND2Date function expects a numeric datetime argument containing a number of days since January 1, 1900, and a datetime format string. It returns the date represented by the first argument, in the format corresponding to the second argument. $Sir_ND2Date accepts an optional error control string and returns the null string if an error is detected.
Syntax
%dat = $Sir_ND2Date(datn, fmt, errctl)
Syntax terms
| %dat | Set to the datetime value string, using format specified by fmt, corresponding to datn, unless an error is detected. |
|---|---|
| datn | Datetime number containing a signed number of days since January 1, 1900. |
| fmt | Datetime format string. Refer to "Datetime string formats" for an explanation of valid datetime formats and valid datetime values. |
| errctl | Optional error control string; refer to "Datetime error handling". |
Usage notes
- The inverse of this $function is $Sir_Date2ND.
- $Sir_ND2Date returns a null string in the following cases:
- fmt is not a valid datetime format.
- datn out of range.
Example
The following fragment prints the string 07/31/84:
%x = $Sir_Date2ND('8407301230', 'YYMMDDHHMI') + Add a day: %x = %x + 1 Print $Sir_ND2Date(%X, 'MM/DD/YY')