julienne date

[Memo]

Hi I have a table, one date field is in the julienne date format "39656" how
can I convert this field to short date?

 

[Douglas J. Steele]

There are actually several different definitions for Julian date. What date
is 39656 supposed to represent?

 

[John W. Vinson]

Hi I have a table, one date field is in the julienne date format "39656" how
can I convert this field to short date?

The term "Julian date" (named after Julius Caesar) has various definitions,
but usually would refer to either the Astronomical Julian Date, the number of
days since January 1, 4713 BCE Greenwich noon; or a shorthand date consisting
of the (two or four digit) year number and days in the year, e.g. 11/13/2009
would be either 09316 or 2009316.

Since neither 1939 nor 2039 have a 656th day, and since 39656 would be in the
fourth millenium BCE on the Astronmical Julian Date scheme, I'm doubtful that
either is relevant for your example.

Where are you getting this finely shredded date number? Might it be from
Excel? If so the starting point is December 30, 1899 and you could use

DateAdd("d", #12/30/1899#, [juliennedate])

but do check to see if that agrees with your other information, since the
definition of your date field is ambiguous!

 

[John W. Vinson]

Or maybe we are missing the simplest explanation, that its just Access's own
date/time implementation with its origin at #December 30 1899 00:00:00#.

'duh'

Very possible, though I'm not sure how 'memo' would have exposed this value.

Maybe he or she will post back and let us know.

 

[jacksonmacd]

I am glad that someone as respected as John Vinson also thought this
question should be on a cooking show. ;-)

 

[James A. Fortune]

Murphy's Law, that's how. Take it from an Irishman, its infallible!

Ken Sheridan
Stafford, England

I get it. Murphy's Law prevents its own infallibility .

James A. Fortune
(e-mail address removed)

A relatively painless way to decrease unemployment is to prevent
companies from colluding to prevent competition. Real competition
creates jobs out of necessity.