Since many application data sources are internally consistent in the date and time formats used, use the options on this tab to limit the number of choices displayed within Relativity (typically in the Transform column of the FD form).
The following table describes the options available on the Date Format tab.
| Option | Description |
|---|---|
| Enable Date/Time Transforms on Table Columns | When selected, the date/time transforms available in the FD form are also available in the table definition form. Selecting this option is discouraged. |
| YYMMDD Format Transforms | When selected, the date transform YYMMDD choices are available. |
| MMDDYY Format Transforms | When selected, the date transform MMDDYY choices are available. |
| DDMMYY Format Transforms | When selected, the date transform DDMMYY choices are available. |
| YYDDD Format Transforms | When selected, the date transform YYDDD choices are available. |
| YYYY Format Transforms | When selected, the date transform YYYY is available for any YY form chosen. For example, if YYMMDD Format Transforms is selected, then selecting YYYY Format Transforms causes YYMMDD and YYYYMMDD date transforms to be available. |
| Days Format Transforms | When selected, the date transform Days is available. The transform represents the number of days since a specific day. |
| HHMM Format Transforms | When selected, the time transform HHMM choices are available. In addition, if Date/Time Format Transforms is selected, HHMM forms of any date transforms are also available. For example, if YYMMDD Format Transforms is selected, then selecting HHMM Format Transforms causes both YYMMDD and YYMMDDHHMM date transforms to be available. |
| HHMMSS Format Transforms | When selected, the time transform HHMMSS is available. In addition, if Date/Time Format Transforms is selected, HHMMSS forms of any date transforms are also available. For example, if YYMMDD Format Transforms is selected, then selecting HHMMSS Format Transforms causes both YYMMDD and YYMMDDHHMMSS date transforms to be available. |
| HHMMSShh Format Transforms | When selected, the time transform HHMMSShh is available. In addition, if Date/Time Format Transforms is selected, HHMMSShh forms of any date transforms are also available. For example, if YYMMDD Format Transforms is selected, then selecting HHMMSShh Format Transforms causes both YYMMDD and YYMMDDHHMMSShh date transforms to be available. |
| Date/Time Format Transforms | When selected, combinations of the selected date and time transforms are available. For example, if Date/Time Format Transforms, YYMMDD Format Transforms, and HHMMSShh Format Transforms are selected, both YYMMDD and YYMMDDHHMMSShh date transforms are available. |
| Configurable Format Transforms | When selected, the end-user configurable 6-digit (and 8-digit, if the Include YYYY Forms option is selected) date transforms are available. See Defining Date Constants . |
| Period Begin/End Format Transforms | When selected, the YYMM01, YYMM31, YY001 and YY365 (and YYYYMM01, YYYYMM31, YYYY001 and YYYY365 if YYYY Format Transforms is selected) date transforms are available. These transforms assume the first or last day of a month or year. |
| 9s Complement (date transform modifier) | When selected, the 9s Complement modifier is available. This modifier subtracts the value of the COBOL data item from all 9's before computing the date or time value using the modified transform. |
| 10s Complement (date transform modifier) | When selected, the
10s Complement modifier is available. This computes the 9s Complement modifier, and then and adds 1 to that value before computing the date
or time value using the modified transform.
Note: The 10s Complement of a zero value is defined to be zero.
|
| 3m Complement (date transform modifier) | When selected, the transforms incorporating the 3m Complement, which complements the value of the COBOL data item with respect to 3,000,000 based on a date format of CYYMMDD, are available. |
| NCR Complement (date transform modifier) | When selected, the NCR Complement modifier is available. This modifier compliments the value of the COBOL data item with respect to 30,000 based on a date format of MMDDYY. |
| + Subscript (date transform modifier) | When selected, the YYDDD, YYDDDHHMM, YYDDDHHMMSS, YYDDDHHMMSShh, YYMMDD, YYMMDDHHMM, YYMMDDHHMMSS, YYMMDDHHMMSShh date transforms are available. Additionally, if this is selected, all of the YYYY formats of the date transforms are available. All of these transforms allow access to combined date and OCCURS items. |