• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Re: Julian dates in Query/400

svdgi

Active Member
Re: Julian dates in Query/400

Hi
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" <Chris.deOrla@sayers.ca> 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!
http://photos.yahoo.com/
 

RBassett

Member
Re: Julian dates in Query/400

Are You absolutely sure ????
Raymond T. Bassett
Systems Group
NEPTCO, Inc.
401-722-5500 x177
401-728-9932 fax
www.neptco.com
rbassett@neptco.com

*******************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.
 
Top