How to convert Julian date to Gregorion date

pnkumar · New User Joined: 27 Oct 2005 Posts: 24

Hi,

I am trying to generate a report using Easytrieve where i need to display the date as Gregorion date by taking the value from the file which is in the Julian date format. Please help me how to convert the Julian (YYYYDDD) date to Gregorian date (DDMMYYYY) in Easytrieve.

Thanks in advance.

Thanks
Kumar

dick scherrer · Posted: Sun Jul 19, 2009 2:40 am

Hello,

Define a 12-entry array with 2 fields per entry. The first field is the month (defined by a literal 1-12. The other field is the number of days in the year before this month (remember to adjust the feb-dec values for leap year).

To build the julian date use the year from your date field and use the month as the subscript into the array. Add the number of days before this month to the day of your date field giving an unsigned 3-digit julian day.

dick scherrer · Posted: Mon Jul 20, 2009 4:44 am

Hello,

Or, make the array items contain 3 fields - 1 for month, 1 for non-leap-year max days and the other for leay-year max days. . .

I mention the field for month to make the code easier for someone to read later. . .

With slight modification, the same process may be used if the month is JAN or OCTOBER or etc.

Douglas Wilder · Posted: Mon Jul 20, 2009 8:26 pm

Or you could use the macro DATECONV that come with Easytrieve.
%DATECONV datein YYDDD dateout MMDDCCYY

dick scherrer · Posted: Tue Jul 21, 2009 2:16 am

Hi Douglas,

Have you successfully used this (DATECONV) to convert from Julian to Gregorian?

I've not been able to find it in the documentation.

d

Douglas Wilder · Posted: Tue Jul 21, 2009 2:32 am

Yes, we have this in production jobs.
I do not remember exactly where I got it but I keep a copy of a page from "5-4 CA-PanAudit Plus MVS Macro Reference Guide" "Generalized/Statistical Routines D-E 5-5" that gives the syntax.

dick scherrer · Posted: Tue Jul 21, 2009 3:08 am

Thanks Douglas

Now, if they'll only include it in the EZT documentation - i was searching in the R11 doc and did not see it. Hopefully, it was not removed. . .

d

Bill Murrell · Posted: Fri Jul 24, 2009 7:00 pm

Most shops I'e worked in have pre-written programs that can be called to do the various date conversions needed. Have you tried asking your peers to see if there are such programs at your shop?