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



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

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

Postby rajupatil3553 » Mon Oct 10, 2016 12:31 pm

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
rajupatil3553
 
Posts: 2
Joined: Mon Oct 10, 2016 12:12 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby NicC » Mon Oct 10, 2016 2:45 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post