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.
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 . 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.