SeanHoppe.com CLEO Mapping Examples 3
Date Conversion with Code Table: DATECONVRT
In the example below we are receiving an inbound date in the format of YYMMDD. We need to convert the data to CYYDDD
Date Formats available to use:
Code Date format
Y YY
M MM
D DD
C C (0,1,...9)
CC CC (19,20,...28)
Z CCYY
ISO CCYY-MM-DD
ISU MM/DD/CCYY
JUL YYDDD
JDY DDD
CJL CYYDDD where C = century digit (0 = 19xx; 1 = 20xx etc.) YMD YYMMDD
ZMD YYYYMMDD
MDY MMDDYY
MDZ MMDDYYYY
DMY DDMMYY
DMZ DDMMYYYY
CMD CYYMMDD where C = century digit (0 = 19xx; 1 = 20xx etc.)
Example:
Convert between YYYYMMDD in standard and MMDDYY in local:"Code qualifier" parameter is 'ZMDMDY'
Location of Source Code:
EXTSYS/QRPGSRC/DATECONV
By: Sean Hoppe on
