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.
Date Adjustment Values
- None
- Specifies
that an aging increment is not used.
- Years, Months, Weeks, Days
- Adjusts the date incrementally by the 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. (You can define calendars and rules by
selecting . 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:
- 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.
- 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 |
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 Optim™ Support.