>From Wikipaedia: The Julian date (JD) is the interval of time in days and fractions of a day since January 1, 4713 BC Greenwich noon
However it looks as though your 'Julian Dates' are actually the day number not the Julian date. John Weller 01380 723235 07976 393631 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Jon Westcot > Sent: 14 January 2011 18:13 > To: [email protected] > Subject: Re: I have some data in year julian day form , how do i convert to a date > > Hi Mike: > > I think that the VFP Julian date usage is a "number of days from X" sort > of function, whereas your dates are the "number of days within the year" > type. You're probably gonna have to roll your own function to convert > these, but that should be really straightforward (as long as you don't mind > dealing with leap years <g>). > > Good luck. > > Jon > > > ----- Original Message ----- > From: Michael Savage > To: [email protected] > Sent: Friday, January 14, 2011 11:58 AM > Subject: I have some data in year julian day form , how do i convert to a > date > > > 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/[email protected] ** 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.

