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