User Tools

Site Tools


age_return_age_from_base_date_.htm
Navigation:  Language Reference > 13 - Built-in Functions >====== AGE (return age from base date) ====== Previous pageReturn to chapter overviewNext page

AGE(birthdate [,base date])

blk2blue.jpg

AGE Returns elapsed time.
birthdate A numeric expression for a standard date.
base date A numeric expression for a standard date. If this parameter is omitted, the operating system date is used for the computation.

The AGE procedure returns a string containing the time elapsed between two dates. The age return string is in the following format:

1 to 60 days         - 'nn DAYS'

61 days to 24 months - 'nn MOS'

(2 years + 1 month) to 999 years - 'nnn YRS'

Return Data Type: STRING

Example:

Message = Emp:Name & 'is ' & AGE(Emp:DOB,TODAY()) & ' old today.'

See Also:

Standard Date

DAY

MONTH

YEAR

TODAY

DATE

age_return_age_from_base_date_.htm.txt · Last modified: 2021/04/15 15:56 (external edit)