Date Conversion DATECONVRT

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



EXTOL EEI DATECONVRT

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: on
EXTOL Business Partner Logo

More EXTOL Examples

We have over 300+ examples of how EXTOL can be customized to meet your organization's needs

Each of our exmaples are free to review and use.