Age Function Tab

Use the Age Function tab to provide parameters for the age function in a column map.

The values on this tab 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 columns mapped with incomplete age function specifications.

Load Request Editor with Age Function as the active tab. The elements of the Age Function tab are described in the following text.

Date Adjustment Values

None
An aging increment is not used.
Years, Months, Weeks, Days
Source dates are adjusted by a specified number of increments. Use any, all, or none of the following to adjust a date.
Years
-2500 to +1581
Months
-30000 to +30000
Weeks
-30000 to +30000
Days
-99999 to +99999
Specific Year
Adjust the source date to a specific four-digit year from 1582 to 3999.
Specific Date
Adjust the source date to a specific date. To select a date from a perpetual calendar, click the down arrow. The date format is based on the Regional Settings on the Control Panel of your computer. If you do not specify a date, the current system date displays.
Base/Target
Adjust the source date by a calculated amount. The calculated 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 the down arrow.
Base
Specify an explicit start date for calculating the aging amount.
Target
Specify an explicit end date for calculating the aging amount.
Multiple/Rule
Adjust the source 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, from 1 to 30000, to apply the specified rule for date aging.
Rule
Name of the rule to use.

Date Adjustment Options

Define calendars and rules by clicking Utilities > Calendar from the menu.
Calendar
The name of the calendar to use by default. To select from a list of available calendars, click the down arrow.
Rule
The name of the rule to use by default. To select from a list of available rules, click the down arrow.
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

Use 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
Y/M/D 1999/99/99
9999/99/99
9999/12/31
1900/0/0
2000/0/0
0/0/0
1/1/1
Y/J 1999/999
9999/999
1900/0
2000/0/0
0/0
Y/M 1999/999
9999/999
1900/0
2000/0
0/0
Y 9999
0
M/D 99/99
0/0
M 99
0/0
D 9/9
0/0

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



Feedback