Converting Julian dates

GCC Consulting gcc at optonline.net
Fri Nov 12 07:48:55 PST 2004


 

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of Kenneth Brody
> Sent: Friday, November 12, 2004 9:38 AM
> To: rkreiss at gccconsulting.net
> Cc: filePro mailing list
> Subject: Re: Converting Julian dates
> 
> rkreiss at gccconsulting.net wrote:
> > 
> > > GCC Consulting wrote:
> > >>
> > >> Does anyone have a formula(filepro code) for converting Julian 
> > >> values to normal dates?
> > >
> > > Which type of "Julian value" are you converting?
> > >
> > Ken,
> > 
> > These are values from an excel spreadsheet i.e. 38019 
> appeared in the 
> > cell for feb - 04  date may have been 2/1/04 or 2/2/04.
> 
> Sounds to me like this "Julian date" is simply a count of 
> days, starting at 1-Jan-1900.  Add that number to 
> "12/31/1899" and you get "02/03/2004".
> 
Thanks, that did it.

Richard Kreiss
GCC Consulting 




More information about the Filepro-list mailing list