Converting Julian dates
Kenneth Brody
kenbrody at bestweb.net
Fri Nov 12 19:23:35 PST 2004
John Esak wrote:
>
> <top-posted>
>
> No offense guys... but, just how the hell would either of your responses as
> wonderfully "technical" and "correct" and "looked-up" as they are have
> helped Richard in his question about using the "Julian Date"?? :-) My
> simple answer went one heck of a lot further toward being helpful than
> either of yours and just once, I'm going to state so. If the goal is helping
> other here, great, if it is helping one's own ego in who can "google up" the
> quickest -definition-... well, I'd op for the useful less *genuine* answer.
[...]
You must have missed the part where I quoted this answer from Richard:
> > 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.
That told me that his "Julian date" was a count of days, with 1-Jan-1900
as the epoch. Hence, my answer of "add the number to 12/31/1899" was what
Richard needed, as noted by his followup:
> Thanks, that did it.
Once Richard's problem was solved, the discussion then turned to the
technical side of what "Julian date" means.
Did you see my previous message on this, or did some spam filter generate
a false positive on it?
--
+-------------------------+--------------------+-----------------------------+
| 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