http://wiki.signature.net/index.php?action=history&feed=atom&title=IB_Statements%2Fnumtodate 2026-04-18T20:21:33Z Revision history for this page on the wiki MediaWiki 1.16.0 http://wiki.signature.net/index.php?title=IB_Statements/numtodate&diff=450&oldid=prev 2009-05-22T12:00:12Z

<p>New page: &#39;&#39;&#39;NUMTODATE function&#39;&#39;&#39; &#39;&#39;&#39;Syntax:&#39;&#39;&#39; NUMTODATE(numeric-argument) &#39;&#39;&#39;Discussion:&#39;&#39;&#39; The NUMTODATE function converts a date serial number to the corresponding date string. The num...</p> <p><b>New page</b></p><div>'''NUMTODATE function''' <br /> <br /> '''Syntax:''' NUMTODATE(numeric-argument) <br /> <br /> '''Discussion:''' The NUMTODATE function converts a date serial number to the corresponding date string. <br /> <br /> The numeric-argument is a 6-digit value (variable or constant) that represents the number of days elapsed from a given base date. The base date is January 1, 1800. The greatest date covered by this function is December 31, 2299. The following chart demonstrates these values. <br /> <br /> Date serial number Date string Notes<br /> ==================================================<br /> 0 &quot;01011800&quot; Base date<br /> 182620 &quot;12312299&quot; Maximum value<br /> <br /> This function returns an 8-byte date string in the following form: &quot;MMDDYYYY&quot; <br /> If the value of the numeric-argument is less than 0 or greater than 182620, the DATETONUM function will return an 8-byte string containing the following values: &quot;000000&quot; <br /> <br /> The NUMTODATE function respects the rules for leap years (i.e., the years 1800 and 1900 were not leap years, but the year 2000 is a leap year). <br /> <br /> The DATETONUM function converts a date string to a date serial number. <br /> <br /> Also see DATE2NUM and NUM2DATE. <br /> <br /> '''Example:'''<br /> LENGTH 8 &amp; LOCAL VALUE$<br /> LENGTH 6.0 &amp; LOCAL SERIAL<br /> . <br /> .<br /> .<br /> PRINT (0) &quot;ENTER A DATE SERIAL NUMBER (######):&quot;<br /> INPUT (0) SERIAL<br /> IF SERIAL = 0 THEN RUN &quot;QMONITOR&quot;<br /> VALUE$ = NUMTODATE(SERIAL)<br /> PRINT (0) &quot;THE DATE STRING IS:&quot;;VALUE$</div>

Badge