Age Function Tab

Use the Age Function tab to specify parameters for aging data when using the Age function in a Column Map.

These values are applied to columns for which you specify the Age function as AGE(DEF) or AGE(RU=DEF). These values are also used to complete the specifications for date adjustment values in columns defined with the Age function when the specifications are incomplete.

Age Function tab selected on the Load Request Editor

Date Adjustment Values

None
Specifies that an aging increment is not used.
Years, Months, Weeks, Days
Adjusts dates incrementally by a specified number of years, months, weeks, and/or days. Use a minus (-) sign to decrement the date. The plus (+) sign is not required to increment the date.
Years
Number of years (-2500 to +1581) to adjust the date.
Months
Number of months (-30000 to +30000) to adjust the date.
Weeks
Number of weeks (-30000 to +30000) to adjust the date.
Days
Number of days (-99999 to +99999) to adjust the date.
Specific Year
Adjusts the date to a specific four-digit year (1582 to 3999).
Specific Date
Adjusts the date to a specific date. To select a date from a perpetual calendar, click on the down arrow. Click the arrow buttons to set the month and year. Click on a day to set the day of the month.
Note: If you do not specify a date, the system (current) date displays. The date format is based on the Regional Settings on the Control Panel of your computer.
Base/Target
Adjusts the date incrementally by a calculated aging amount. The aging amount is the number of days between the Base date and the Target date. To select a base or target date from a perpetual calendar, click on the down arrow. Click the arrow buttons to set the month and year. Click on a day to set the day of the month.
Base
Specify an explicit start date for calculating the aging amount.
Target
Specify an explicit end date for calculating the aging amount.
Multiple/Rule
Adjusts the date by applying the specified date aging rule the specified number of times. For example, if the rule is defined as NEXTPAYDAY and you specify 4 as the multiple, the date is adjusted from the source date to the fourth NEXTPAYDAY.
Multiple
Number of times (1 to 30000) to apply the specified rule for date aging.
Rule
Name of the rule to use.

Date Adjustment Options

Calendar
Enter the name of the calendar to use by default. To select from a list of available calendars, click the down arrow.
Rule
Enter the name of the rule to use by default. To select from a list of available rules, click the down arrow.
Note: Define calendars and rules by clicking Utilities > Calendar. For details on defining calendars and rules, see the Common Elements Manual.
Century Pivot
Enter the value to use to determine the appropriate century when a date value is defined with a two-digit year. If you do not specify a value, 65 is used by default. For example, if you specify 55 as the Century Pivot, then:
  • All two-digit years equal to or greater than 55 are assumed to be in the 20th century.
  • All two-digit years less than 55 are assumed to be in the 21st century.

Exception Options

Select the following exception options to handle special date values when aging data. Rather than treat these dates as errors, the dates are moved directly from the source to the destination if the column attributes are identical.

At times, special values called skipped dates are used to indicate special handling or unique conditions. To determine whether or not to skip a date, the date aging function evaluates each date for the following:

The date aging function recognizes the following as skipped dates:

Date Format Skipped Date Value Date Format Skipped Date Value
Y/M/D 1999/99/99 Y/M 1999/999
9999/99/99 9999/999
9999/12/31 1900/0
1900/0/0 2000/0
2000/0/0 0/0
0/0/0 Y 9999
1/1/1 0
Y/J 1999/999 M/D 99/99
9999/999 0/0
1900/0 M 99
2000/0/0 0/0
0/0 D 9/9
  0/0

This list is intended to be as comprehensive as possible. If you require additional skipped dates, contact Technical Support.