[Bulk] Julian date

[Ken Langendock]

Try this

 

; Julian Date Calculations

  DEFINE D-CurrentYY CHARACTER * 2 &

       = ASCII(SYSDATE,8)[3:2]

  DEFINE D-JanuaryFirst DATE &

       = NCONVERT(ASCII(SYSDATE,8)[1:4] + "0101")

  DEFINE D-CurrentDay CHARACTER * 3 &

       = ASCII(DAYS(SYSDATE) &

       - DAYS(D-JanuaryFirst) + 1,3)

  DEFINE D-JulianDate CHARACTER * 5 &

       = D-CurrentYY &

       + D-CurrentDay

 

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Lowe, Chuck J
Sent: March 15, 2010 10:59 AM
To: powerh-l at lists.sowder.com
Subject: [Bulk] Julian date

 

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. 

 

Thanks!

 

Chuck Lowe Quest Diagnostics | Sr. Programmer/Analyst,SYS Billing
System/Denver| 400 Egypt Rd. | West Norriton, PA 19403 USA | phone
610-650-6679| fax 610-650-2111 |
<mailto:Chuck.J.Lowe at questdiagnostics.com> Chuck.J.Lowe at questdiagnostics.com
|  <http://www.questdiagnostics.com/> www.QuestDiagnostics.com 

Please think about resource conservation before you print this message

 


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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2748 - Release Date: 03/15/10
03:33:00

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100315/0979ee5a/attachment.htm