GET_YEAR Function
Description: Return the year for the date provided. This function is only valid for data elements with a processing type of date.
Parameters: String
- Source date: The string containing the source date value.
Return: Integer containing the year.
Syntax: GET_YEAR(<source date>)
Example: Age birthday by five years for people born more than five years before the current year.
if ( GET_YEAR( DE("Birth Date").getOriginalValue( ) ) <
( GET_YEAR( CURRENT_DATE() ) -5) ) then
{
DE("Birth Date").setValue
( ADD_YEARS( DE("Birth Date").getOriginalValue( ), -5 ) );
}
( GET_YEAR( CURRENT_DATE() ) -5) ) then
{
DE("Birth Date").setValue
( ADD_YEARS( DE("Birth Date").getOriginalValue( ), -5 ) );
}
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*