Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Date functions > Year function |
|
|
| Year function |
| Format |
Year(date) |
| Parameter |
| date - any calendar date |
| Data type returned |
| number |
| Description |
| Returns a number representing the year in which date occurs. For example, you can extract the year from a field containing the date an item sold. |
| Important To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Conversion of dates with two-digit years. |
| Examples |
| Year(DateSold) returns the year stored in DateSold. |
| Year("5/5/2008") returns 2008. |
| Year(Date(Month(Get(CurrentDate)) + 48;Day(Get(CurrentDate));Year(Get(CurrentDate)))) returns the year that is 48 months from today's date. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Date functions > Year function |
|
|
Next Page |
|