EncodeDate
Revision as of 12:27, 19 January 2012 by 194.84.116.138 (talk) (Created page with "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 ...")
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
Example
EncodeDate(08,01,01) will return a value of 39448.00000000, corresponding to the specified date
of January 1st, 2008