Date conversion using DFSORT

bamohan · New User Joined: 29 Jan 2007 Posts: 33 Location: chennai

Hi, I want to convert a julian date format yyyyddd to gregorian date format in yyyy-mm-dd. that is I need the ' - ' in the date format. Please let me know how to acheive that

Date conversion using DFSORT

CICS Guy · Posted: Tue Mar 17, 2009 8:35 pm

Take a look at DATE1(c)...

Frank Yaeger · Posted: Tue Mar 17, 2009 9:40 pm

bamohan,

What is the starting position and format (CH, PD?) of your input julian date?

What is the starting position of your output gregorian date.

What is the RECFM and LRECL of the input file and output file?

CICS guy,

DATE1(c) creates a constant for the current date. The OP is asking about converting a field in julian date format to a field in gregorian date format which has nothing to do with DATE1(c).

bamohan · New User Joined: 29 Jan 2007 Posts: 33 Location: chennai

Hi,

Input File RECORD LENTH is 814 and O/p File REC LENGTH is 58. Record Format is FB for both.

The Input file Julian date starts from the position 484 - 487. Julian date is in the format yyyyddd. The o/p gregorian date should start from the position 18 in the o/p file and in the format YYYY-MM-DD.

Please help !!!

vinothsubramanian · Posted: Wed Mar 18, 2009 8:22 pm

Hi Bamohan,

I assume that the Julian date is in PD format from 484 to 487.

Try the following code and let us know your result:

vinothsubramanian · Posted: Thu Mar 19, 2009 10:41 am

You can try also this: