Re: Convert Julian Hex Date to Another Format

On Mon, Nov 24, 2014 at 11:23 AM, Brian <belstsrv@xxxxxxxxx> wrote:

I am receiving from an ERP system a hex value for a Julian date. This is a
real Julian date, not a JDE type of date. Ultimately I need to convert this
to YYYYMMDD format.

What do you mean by "real Julian date"? The term "Julian date" is
used for at least a couple of different things. It's particularly
confusing in the IBM midrange community (though some folks *in* the
IBM midrange community don't know this :P ).

The hex is just simple text like this: 257D96
This hex should convert to a decimal value of: 2456982

OK, that part is straightforward enough to understand, and is unambiguous.

I was able to use 'cvtch' to get my text representation of the hex number
converted in to real hex. But, I've tried the overlay method of getting the
decimal equivalent of the hex number and that has not worked.

What do you mean by "overlay method"? In principle, you should be
able to just plop a hex value into a data structure and read it out as
any RPG type you like. In this case, I imagine you would want a
4-byte binary integer (pad the input with zeros on the left).

Once you can get an integer, can you do the necessary conversion to a
usable date form, or do you need help with that as well?

John Y.