Converting Julian dates

Kenneth Brody kenbrody at bestweb.net
Fri Nov 12 06:38:23 PST 2004


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".

-- 
+-------------------------+--------------------+-----------------------------+
| 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