Progress
Report Builder
User’s Guide


YEAR

Evaluates a date expression and returns the year value of that date, including the century, as a numeric value.

SYNTAX

YEAR ( date ) 

date

A date expression (a constant, field name, or expression that results in a date value) for which you want to determine the year.

EXAMPLE

To calculate the year number of the Birthdate field, create a calculated field containing this expression:

YEAR(Birthdate) 

Sample data:

Birthdate     YEAR(Birthdate)
12/10/67      1967
11/19/71      1971 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095