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.
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 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.
- Process rows with invalid dates — If you select this check box, rows with columns that contain invalid
dates are processed and the results are written to the destination.
If you clear the check box, the rows are discarded and are noted in
the Control File.
- Process rows with skipped dates — If you select this check box, rows with columns formatted as skipped
dates are processed and the results are written to the destination.
If you clear the check box, the rows are discarded and are noted in
the Control File.
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:
- If a date column contains all spaces, hexadecimal
zeros (low values), or hexadecimal 'FF' (high values), the date is
skipped.
- If a date column contains a skipped date value,
the value is parsed based on the specified date format or exit routine.
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.