Re: Julian dates in Query/400


Active Member
Re: Julian dates in Query/400

There is no way to convert a julian date to gregorian
date in AS/400 Query.
But if u can do it using an extra file in your
query.JDE world has a file F00365 which has date in
all version.
Just include this file when u build a query.

Good luck

--- "de Orla, Chris" <[email protected]> wrote:
> I know I've seen this before in here, but can't seem
> to find it. Is there a
> way to convert a julian date to a gregorian date in
> an AS400 Query and what
> is the formula to do so ?
> Thanks,
> Cd

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
Re: Julian dates in Query/400

Are You absolutely sure ????
Raymond T. Bassett
Systems Group
401-722-5500 x177
401-728-9932 fax
[email protected]

*******************Internet Email Confidentiality Footer*******************
Privileged/Confidential Information may be contained in this message. If
you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone. In such case, you should destroy this message and kindly
notify the sender by reply email. Please advise immediately if you or your
employer do not consent to Internet email for messages of this kind.
Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by it.