Age (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

See also

Age (Function)

In french: Age

Returns the age according to the date of birth.

Versions 25 and later

This function is now available in browser code.

New in version 25

This function is now available in browser code.

Example

Age("19690513", "20051010")
// Returns "00360427" which means 36 years, 4 months and 27 days

Age("19730912", "20050812")
// Returns "00311100" which means 31 years and 11 months

// How old are you?
dMyAge is Date
dMyAge = Age("19790201", "20061025")
InfoBuild("Your age is: %1 years %2 months %3 days", ...
dMyAge..Year, dMyAge..Month, dMyAge..Day)
// Displays: "Your age is: 27 years 08 months 24 days"

Syntax

<Result> = Age(<Date of birth> [, <Calculation date>])

<Result>: Character string

Age in years, months and days in YYYYMMDD format. It represents the number of years, months and days between the date of birth and the calculation date.
Empty string ("") if an error occurred (date of birth after the calculation date or invalid date).

<Date of birth>: Character string, Date or DateTime variable

Date of birth. This date can correspond to:
a character string in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD to the day).
Versions 24 and later
a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
New in version 24
a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
a Date variable.
Versions 24 and later
a DateTime variable. In this case, only the date is taken into account.
New in version 24
a DateTime variable. In this case, only the date is taken into account.
a DateTime variable. In this case, only the date is taken into account.

<Calculation date>: Optional character string, Date or DateTime variable

Date in relation to which the age is calculated.
This date can correspond to:
a character string in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD to the day).
Versions 24 and later
a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
New in version 24
a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
a Date variable.
Versions 24 and later
a DateTime variable. In this case, only the date is taken into account.
New in version 24
a DateTime variable. In this case, only the date is taken into account.
a DateTime variable. In this case, only the date is taken into account.
If this parameter is not specified, today's date is used by default.

Related Examples:

Unit examples (WINDEV): Calculating the date of Easter and an age

[ + ] Calculating the date of Easter for a given year and calculating the age of a person at a given date.

Business / GUI classification : Neutral code

Component : wd250std.dll