IBM Mainframe Forum

Hi,
Need ur help.

I have an input date which is in YYDDD format. I need to convert it to MM-DD-YYYY format using SORT.

Input:
14012
19012
16156

Output:
01-12-2014
01-12-1919
06-04-1916

Kindly help!

Thanks in advance!

The required job ia being done using either of the below sort cards:

SORT FIELDS=COPY
INREC BUILD=(1:1,5,Y2T,TOGREG=(Y4T(-)))


OR

SORT FIELDS=COPY
INREC BUILD=(1:1,5,Y2T,DT=(4MD/))


But the issue is that for the input date as 19012, it is giving output as 2019-05-03. But i want 1919-05-03 in output.

I've a feeling that because your date range is 102 years, you won't be able to do it like that anyway. Have a little search in the DFSORT documentation, for the word "window". I think you'll need additional coding. You must have some formula for knowing, already. Does it have to change each year?

@ BillyBoyo: Yes... it will change every year.
The functionality would be same as per GOADTE01 date converter utility with no offset range defined for date conversion.

Well, if you have a range of more than 100 years, strictly, more than 99 years, you need additional information to be able to know which century to attach to a date. If your range is 1916-2015, then when a 12 appears as the year, DFSORT is going to treat it as 2012. If there is other information on the record to identify it as not 2012, you have to use that information yourself. How did you know the date was wrong? Use that.

Well, that was checked using GOADTE01 utility in Workbench.

play around with

using different window year to find out a behaviour acceptable to Your environment

I googled GOADTE01 and got 0 hits so I guess that is some internal utility unknown to anyone except those that work in your company so mentioning it here, by name, is pointless!

Yes NicC... you are correct it is being used in our company. Thanks

Anyways, i got the approach for the abvoe requirement...
Whenever the date conversion is happening... the lowest cut-off date is calculated as (CURRENT-YEAR - 99) and then it is compared with the input date and then the date conversion takes place.

Will post the actual solution once we are done with its build...

Thanks all for your help!