Hi Mike try nRealRuntime = ((Val(Sys1)) - 245552) * 86400) + Seconds()
Sys(1) is VFP call Julian Begining Date less days since then 245552. see Wiki, times No. Sec in a day + seconds since midnight. At midnight you get the rollover of seconds for each day hence the need for the Julian basis. William Tormey AML On Fri, 2011-01-14 at 12:58 -0500, Michael Savage wrote: > I have inherited some data this is stored in year, julian day format... > how do I get the date back > > ie year=1998, julday=58 > I tried sys(10,58) and I get an empty date... > > I thought of another way, just add the julday to the start of year and > this will give me the date??? or have I misunderstood this whole julian > thing? > > TIA, > Mike > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1295030386.3180.6.camel@client ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
