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