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