Optim supports a variety of internal date storage schemes.
For instance, a YYMMDD date field may be stored as a:
Character formats and numeric formats, as either packed decimal or binary fields, are allowed for any format without delimiters.
The following includes examples of date formats. You can display a list of valid formats for a specific field using the asterisk, “*”, in the date format field.
The following formats are provided for MLE COBOL date format.
YYXX YYXXX YYXXXX YYYXXX YYYXXXX YYYYXXXX
Two formats are included in the distributed PSAPFMTS to describe dates used in the software applications distributed by Geac Computer Corporation. This is not used by Optim, but should be retained as is to simplify future upgrades. They are:
| Field | Date Format | Example |
|---|---|---|
| 3-byte decimal | D1900R1 | January 1, 1900 is day 1 |
| 7-byte decimal | YYYMMDDX | First 3 ½ bytes are YYYMMDD |