Troubleshooting
Problem
An Impromptu report accesses a Mapics database. Date data types from this database use a 2 or 3 digit year. For example, 021012 instead of 2002/10/12 and 980801 for 1998/08/01. Impromptu sees the field as a packed decimal column, length 4, precision 7. How can the date be converted to a regular, Gregorian calendar date, so that it can be formatted and date functions can be used against it?
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 7.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
119414
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21333308