<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=953372521-01042007>Hi Ron,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=953372521-01042007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=953372521-01042007>try the following, but note that it doesn't do century
transitions ...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=953372521-01042007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=953372521-01042007>num_jdetfrdte is the julian date </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=953372521-01042007>t_tfrdte is the gregorian one</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=953372521-01042007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2> <BR>
<BR>define t_jyear num*2 =
floor(num_jdetrfdte/1000)
<BR>define t_jday num*3 = num_jdetrfdte - (t_jyear * 1000)
<BR>define t_yearstart num*8 =
&
<BR> ncon(ccon(1900 + t_jyear) +
"0101")
<BR>define t_trfdte date =
&
<BR> date((days(t_yearstart) +
t_jday)-1) </FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=953372521-01042007>cheers</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT><FONT><SPAN class=953372521-01042007></SPAN><FONT
face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=953372521-01042007>Richard</SPAN> <BR>
</FONT></FONT></FONT></FONT></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+richard.latimer=airways.co.nz@lists.sowder.com
[mailto:powerh-l-bounces+richard.latimer=airways.co.nz@lists.sowder.com] <B>On
Behalf Of </B>lorcan-computers@fsmail.net<BR><B>Sent:</B> Friday, 30 March 2007
9:06 p.m.<BR><B>To:</B> powerhouse<BR><B>Subject:</B> Convert Julian
dates<BR></FONT><BR></DIV>
<DIV></DIV>
<P>Does anyone have a bit of quiz/qtp code to convert Julian dates to Gregorian
ones</P>
<P>Cheers</P>
<P> </P>
<P>Ron</P>
<p><span style="font-family:'Arial';font-size:8pt;">**********************************************************************</span></p>
<p><span style="font-family:'Arial';font-size:8pt;">This electronic message together with any attachments is confidential. If</span></p>
<p><span style="font-family:'Arial';font-size:8pt;">you receive it in error: (i) you must not use, disclose, copy or retain</span></p>
<p><span style="font-family:'Arial';font-size:8pt;">it; (ii) please contact the sender immediately by reply email and then</span></p>
<p><span style="font-family:'Arial';font-size:8pt;">delete the emails. Views expressed in this email may not be those of the</span></p>
<p><span style="font-family:'Arial';font-size:8pt;">Airways Corporation of New Zealand Limited</span></p>
<p><span style="font-family:'Arial';font-size:8pt;">**********************************************************************</span></p>
<p><span style="font-family:'Arial';font-size:8pt;"> </span></p></BODY></HTML>