• 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!

Julian dates in Query/400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C075AC.BE96E18E
Content-Type: text/plain;
charset="iso-8859-1"

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

------_=_NextPart_001_01C075AC.BE96E18E
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Julian dates in Query/400</TITLE>
</HEAD>
<BODY>



<FONT SIZE=3D2>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 ?</FONT></P>



<FONT SIZE=3D2>Thanks,</FONT>
</P>



<FONT SIZE=3D2>Cd</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C075AC.BE96E18E--
 

scott_parker

Reputable Poster
Link to the F00365 file.
ONDTEJ is the Julian date ONDATE is the converted date.

Make sure its populated first of course.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
 

ekempter

Administrator
DATEG date(substr(digits(DATEJ+1900000),2,7))



Place your system configuration information in your signature!
 
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C075B2.2BDE902E
Content-Type: text/plain;
charset="iso-8859-1"

Right on !!

I just found it in the JDE List Archives....

Thanks for your help !!






Chris de Orla
Consultant
World Software V7.3.12 AS400 V4R4
 
Top