Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 761
This expression concatenates the characters in the emp_fname and emp_lname
columns and makes the first letter of each word uppercase:
WordCap(emp_fname + " " + emp_lname)
Year
Description Gets the year of a date value.
Syntax Year ( date )
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 set as follows. If the year is between
00 to 49, the first two digits are 20; if the year is between 50 and 99, the first
two digits are 19.
Usage Obtains the year portion of date. Years from 1000 to 3000 inclusive are
handled.
If your data includes dates before 1950, such as birth dates, always specify a
4-digit year so that
Year (and other functions, such as Sort) interpret the date as
intended.
Regional settings
To make sure you get correct return values for the year, you must verify that
yyyy is the Short Date Style for year in the Regional Settings of the user’s
Control Panel.
Examples This expression returns 2005:
Year(2005-01-31)
See also
Day
Month
Argument Description
date The date value from which you want the year