EncodeDate: Difference between revisions
From MultiCharts
(→Usage) |
m (→Usage) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight. | The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight. | ||
== Usage == | |||
<syntaxhighlight>EncodeDate(yy, MM, dd)</syntaxhighlight> | |||
==== | Where: | ||
<syntaxhighlight>EncodeDate(08,01,01) | |||
of January 1st, 2008 | :'''yy''' - a numerical expression specifying the two-digit year. | ||
:'''MM''' - a numerical expression specifying the month. | |||
:'''dd''' - a numerical expression specifying the day of the month. | |||
== Notes == | |||
* Use [[EncodeTime]] to return the fractional portion of a double-precision decimal DateTime value corresponding to a specified time. | |||
== Example == | |||
<syntaxhighlight>EncodeDate(08, 01, 01)</syntaxhighlight> | |||
Will return a value of 39448.00000000, corresponding to the specified date of January 1st, 2008. | |||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] | ||
Latest revision as of 13:07, 19 February 2012
Returns the integer portion of a double-precision decimal DateTime value corresponding to the specified date.
The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight.
Usage
EncodeDate(yy, MM, dd)Where:
- yy - a numerical expression specifying the two-digit year.
- MM - a numerical expression specifying the month.
- dd - a numerical expression specifying the day of the month.
Notes
- Use EncodeTime to return the fractional portion of a double-precision decimal DateTime value corresponding to a specified time.
Example
EncodeDate(08, 01, 01)Will return a value of 39448.00000000, corresponding to the specified date of January 1st, 2008.
