Age Function Tab, Insert Request Editor

Use the Age Function tab on the Insert Request Editor to adjust dates during an Insert Request by using the Age function.

You must select Show Aging to display the Age Function tab, which you can use to provide parameters for a Column Map used to age data. These values apply when you specify the Age function as AGE(DEF) or AGE(RU=DEF) and are also used, if needed, to complete date adjustment specifications for columns defined with the Age function.

Insert Request Editor with Age Function as the active tab. The elements of the Age Function tab are described as follows.

Date Adjustment Values

Select one of the following options:

None
An aging increment is not used.
Years, Months, Weeks, Days
Dates are adjusted incrementally by the specified number of years, months, weeks, and days.
Years
Number of years (-2500 to 1581) used to adjust the date.
Months
Number of months (-30000 to 30000) used to adjust the date.
Weeks
Number of weeks (-30000 to 30000) used to adjust the date.
Days
Number of days (-99999 to 99999) used to adjust the date.
Specific Year
A four-digit year (1582 to 3999).
Specific Date
A date in the format determined by the Regional Settings on the Control Panel of your computer. Edit the date displayed or select from a perpetual calendar by clicking the down arrow. The system (current) date is the default.
Base/Target
A calculated adjustment for dates equal to the number of days between the Base date and the Target date. Edit the date displayed or select from a perpetual calendar by clicking the down arrow.
Base
An explicit date. The system (current) date is the default.
Target
An explicit date before or after the Base date. If the Target date occurs before the Base date, the adjustment is negative.
Multiple/Rule
A rule-based adjustment. For example, if 4 is the multiple for NEXTPAYDAY, source dates are adjusted to the fourth NEXTPAYDAY.
Multiple
Number of times (1 to 30000) to apply the Rule.
Rule
Name of the rule.

Date Adjustment Options

Calendar
The default calendar. To select from a list of available calendars, click the down arrow.
Rule
The default rule. To select from a list of available rules, click the down arrow.
Note: Define calendars and rules by clicking Utilities > Calendar. For details, refer to the Common Elements Manual .
Century Pivot
The value used to determine the appropriate century for two-digit years. If you do not provide a value, 65 is the default.

For example, if 55 is the Century Pivot:

  • All two-digit years equal to or greater than 55 are assumed to be in the 20th century (19xx).
  • All two-digit years less than 55 are assumed to be in the 21st century. (20xx)

Exception Options

Use exception options to manage invalid or skipped date values.

Process rows with invalid dates
Select this check box to process rows with invalid dates in date columns. Invalid dates are moved directly from the source to the destination if the column attributes are identical. Clear the check box to discard rows with invalid dates.
Process Rows with skipped dates
Select this check box to process rows with skipped dates in date columns. Invalid dates are moved directly from the source to the destination if the column attributes are identical. Clear the check box to discard rows with skipped dates.

At times, special values used to indicate special handling or unique conditions are called skipped dates. A skipped date value is parsed according to the specified date format or exit routine.

In addition to spaces, hexadecimal 00 (low values), or hexadecimal FF (high values), Optim™ 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.