1,501
edits
(→Usage) |
m (Reverted edits by 176.8.90.7 (talk) to last revision by 194.84.116.138) |
||
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: [[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 | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight>EncodeDate(08,01,01) will return a value of 39448.00000000, corresponding to the specified date | <syntaxhighlight>EncodeDate(08,01,01) will return a value of 39448.00000000, corresponding to the specified date |