Converting Julian dates
Kenneth Brody
kenbrody at bestweb.net
Fri Nov 12 16:38:21 PST 2004
John Esak wrote:
>
> >
> > > 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.
>
> Sheesh, did what???
[...]
> Ken's question made most sense... what type of Julian value data are you
> talking about. And what is this about 1-Jan-1900???
You missed the part of his answer that I quoted:
> > 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.
Hence, it's not really a "Julian date", but simply a count of the number
of days starting at 1-Jan-1900. (Similar to how filePro's date entries
in the key file header are counted from 1-Jan-1983.)
--
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody | www.hvcomputer.com | |
| kenbrody/at\spamcop.net | www.fptech.com | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+
Don't e-mail me at: <mailto:ThisIsASpamTrap at gmail.com>
More information about the Filepro-list
mailing list