?DATE(1998,1,1) + 58 gives me 28/02/1998 so I guess that will work OK. John Weller 01380 723235 07976 393631
> -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Michael Savage > Sent: 14 January 2011 17:58 > To: [email protected] > 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.
