Page 1 of 1

How to convert julian date 'YYDDD" to current system date

PostPosted: Mon Oct 10, 2016 12:31 pm
by rajupatil3553
Hi All,

I am generating a monthly report on 1st of every month. in this report I want to exclude the transactions created on 1st of month and prior day should serve as the cutoff date.
Input file date format is Julian'YYDDD'.

input to JCL:input file with julian date format on position 375 and length 5
output: Convert the above julian date to current system date and if transaction creation date = prior to current system date write to outfile1
else for transaction created on current system date write to outfile2

Re: How to convert julian date 'YYDDD" to current system dat

PostPosted: Mon Oct 10, 2016 2:45 pm
by NicC
JCL cannot do this. End of story.

Also, do not post in multiple forums. Choose the most appropriate and post there.

Already posted in DFSort. Locked.