[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Julian Dates (OpenInsight 32-bit Specific) ====
=== At 03 DEC 2003 10:26:00PM Mark B wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
Hi all,



How do we convert an OI internal date to Julian Date format?



Thanks,



Mark
</QUOTE>
----

=== At 10 DEC 2003 11:21AM Gray Cunningham wrote:  ===

<QUOTE>Mark,



I don't believe that there is "built-in" way to Oconv a date into Julian Date format, but I could be wrong.  I have always written my own routine that was specific to the requirement at hand.  It isn't that difficult given the way OI & Arev store dates internally.  Assuming that your date is already in internal format, the following code should work:



JulianDate=YourDate - (Iconv("01/01/" : Oconv(YourDate,"D4/")-4,4,"D")-1)



This gives you the "day-of-the-year"...if you also require the year itself in your Julian Date, you would have to append or prepend it to this value.



Hope this helps,



Gray Cunningham

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=03CB07E37D763C5F85256DF20012DC30|View this thread on the  forum...]]