covert julian date in yyddd to current date in jcl
Posted: Mon Oct 10, 2016 12:29 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 dataset date format is Julian'YYDDD'.
Input: dataset with julian date format at 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
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 dataset date format is Julian'YYDDD'.
Input: dataset with julian date format at 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