YearFromDateTime
Revision as of 13:46, 19 January 2012 by 194.84.116.138 (talk) (Created page with "Returns a numerical value indicating the year for the specified DateTime value. The integer portion of the DateTime value specifies the number of days since January 1st, 190...")
Returns a numerical value indicating the year for the specified DateTime value.
The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.
Usage
YearFromDateTime(DateTime)
Where: DateTime - a double-precision decimal DateTime value
Example
YearFromDateTime(39449.25000000) will return a value of 2008, indicating the year of 2008