<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="http://schemas.microsoft.com/office/2004/12/omml">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
p
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>There is likely no need for Ken’s
complicated conversion logic!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Just define your date item as type “jdate”
and Powerhouse will convert to Julian format. If you are converting from a
century included date then you’ll need to use the removecentury function.
As in:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>>define d-julian-date jdate =
removecentury(sysdate)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>>report sysdate d-julian-date format
yyddd<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Note that any date may be displayed in any
format. Even a jdate will be displayed in the dictionary’s default format
so you’ll probably need to include the format option.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>JWP<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com
[mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Ken Langendock<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, March 15, 2010 11:12
AM<br>
<b><span style='font-weight:bold'>To:</span></b> 'Lowe, Chuck J'; powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [Bulk] Julian date</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Try this<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>; Julian Date
Calculations<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> DEFINE
D-CurrentYY CHARACTER * 2 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
= ASCII(SYSDATE,8)[3:2]<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> DEFINE
D-JanuaryFirst DATE &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
= NCONVERT(ASCII(SYSDATE,8)[1:4] + "0101")<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> DEFINE
D-CurrentDay CHARACTER * 3 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
= ASCII(DAYS(SYSDATE) &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
- DAYS(D-JanuaryFirst) + 1,3)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> DEFINE
D-JulianDate CHARACTER * 5 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
= D-CurrentYY &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
+ D-CurrentDay<o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com [mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Lowe, Chuck J<br>
<b><span style='font-weight:bold'>Sent:</span></b> March 15, 2010 10:59 AM<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Bulk] Julian date<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I must be having a bad day. Can anyone give me the
code to find out the Julian date for a day . I.e. February 2nd would be
33. In QTP would be preferable. </span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks!</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p><b><font size=2 color="#333333" face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;color:#333333;font-weight:bold'>Chuck Lowe </span></font></b><b><font
size=1 color="#006633" face=Verdana><span style='font-size:8.5pt;font-family:
Verdana;color:#006633;font-weight:bold'>Quest Diagnostics</span></font></b><font
face=Verdana><span style='font-family:Verdana'> </span></font><font size=1
color="#666666" face=Verdana><span style='font-size:8.5pt;font-family:Verdana;
color:#666666'>| Sr. Programmer/Analyst,SYS Billing System/Denver| 400
Egypt Rd. | West <st1:place w:st="on"><st1:City w:st="on">Norriton</st1:City>,
<st1:State w:st="on">PA</st1:State> <st1:PostalCode w:st="on">19403</st1:PostalCode>
<st1:country-region w:st="on">USA</st1:country-region></st1:place> | <strong><b><font
face=Verdana><span style='font-family:Verdana'>phone</span></font></b></strong>
610-650-6679| <strong><b><font face=Verdana><span style='font-family:Verdana'>fax</span></font></b></strong> 610-650-2111
| <a href="mailto:Chuck.J.Lowe@questdiagnostics.com"><font
color="#666666"><span style='color:#666666'>Chuck.J.Lowe@questdiagnostics.com</span></font></a>
| <a href="http://www.questdiagnostics.com/"><font color="#666666"><span
style='color:#666666'>www.QuestDiagnostics.com</span></font></a> </span></font><font
face=Verdana><span style='font-family:Verdana'><o:p></o:p></span></font></p>
<p style='margin-bottom:48.0pt'><font size=1 color="#006633" face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:#006633'>Please think about
resource conservation before you print this message<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
------------------------------------------ <br>
The contents of this message, together with any attachments, are intended only
for the use of the person(s) to which they are addressed and may contain
confidential and/or privileged information. Further, any medical information
herein is confidential and protected by law. It is unlawful for unauthorized
persons to use, review, copy, disclose, or disseminate confidential medical
information. If you are not the intended recipient, immediately advise the
sender and delete this message and any attachments. Any distribution, or
copying of this message, or any attachment, is prohibited. <o:p></o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>No
virus found in this incoming message.<br>
Checked by AVG - www.avg.com<br>
Version: 9.0.733 / Virus Database: 271.1.1/2748 - Release Date: 03/15/10
03:33:00</span></font><o:p></o:p></p>
</div>
</body>
</html>