year PowerHome formula function
Description
Gets the year of a date value.
Syntax
year ( date )
| Argument |
Description |
|
date
|
The date value from which you want the year
|
Return value
Integer. Returns an integer whose value is a 4-digit year adapted from the year portion of date if it succeeds and 1900 if an error occurs.
If the year is two digits, then the century is chosen as follows. If the year is between 00 to 49, PowerHome assumes 20 as the first two digits; if it is between 50 and 99, PowerHome assumes 19.
Usage
Obtains the year portion of date. PowerHome handles years from 1000 to 3000 inclusive.
If your data includes dates before 1950, such as birth dates, always specify a 4-digit year so that year and other functions interpret the date as intended