IBM Mainframe Forum

Posted: **Tue May 12, 2009 3:59 pm**

Hi,

I receive date in YYMMDD format and want to convert it to MM/DD/CCYY.

Please help me with a SORT card for this. We use Syncsort v2.

Posted: **Tue May 12, 2009 8:31 pm**

Here is an example of a SyncSort for z/OS 1.2 job that will do what you asked:

Select all

//SORT1 EXEC PGM=SORT,PARM='CENTWIN=80'
//SORTIN DD *
990126
090512
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=INIT,BUILD=(1,6,Y2T)),
IFTHEN=(WHEN=INIT,BUILD=(5,2,C'/',7,2,C'/',1,4))
/*

This is the output produced:

Select all

01/26/1999
05/12/2009

Posted: **Thu May 14, 2009 9:14 am**

Thank you very much

Posted: **Thu May 14, 2009 5:39 pm**

Another method - Just thought to share it here:

Select all

//SORT0001 EXEC PGM=SORT
//SORTIN DD *
090701
710701
/*
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY,CENTWIN=1970
OUTREC FIELDS=(3,2,C'/',5,2,C'/',1,2,Y2C)
/*

Thanks.

IBM Mainframe Forum

convert YYMMDD to MM/DD/CCYY

convert YYMMDD to MM/DD/CCYY

Re: convert YYMMDD to MM/DD/CCYY

Re: convert YYMMDD to MM/DD/CCYY

Re: convert YYMMDD to MM/DD/CCYY