julian date

[nkob]

I have the following Julian date 103230. does anybody know how I can change
it to a Gregorian date i.e.. 8/18/03 in a query.

thanks in advance.

 

[John Vinson]

I have the following Julian date 103230. does anybody know how I can change
it to a Gregorian date i.e.. 8/18/03 in a query.

thanks in advance.

"Julian Date" is a term with many, many definitions: astronomical
Julian date, yyddd Julian date, military julian date (last digit of
the year plus three digit day), and on and on. I don't recognize yours
but I'm guessing that it's years since 1900 (103) and days since the
first of the year (230).

If so, then try

DateSerial(1900 + Val(Left([JDdate], Len([JDate]) - 3)), 1,
Val(Right([JDate], 3))

I'm assuming that January 1, 1999 would be shown as 99001 - if it's
991 you're in real trouble, since 10123 could be January 23, 2001 or
the 123rd day of 1910!

 

[Rebecca Riordan]

John,

I agree with you...to me, "Julian Date" will always mean "the date before
Pope Julius updated the calendar", but I appear to be a minority of one
there (yet again).

But just out of curiosity, do you have any idea when or why "Julian" started
being applied to any date that isn't US standard?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Tony Toews]

I'm not aware of the term being used for *any* date that isn't US
standard. I've never encountered the term in a programming context when
it didn't refer to a format that involved specifying the year and the
sequential day of the year. In the various shops I've worked in, it has
always referred to a format along the lines of 2003.232 or 2003232 or
(pre-Y2K-worries) 03232. If John's interpretation of nkob's date is
correct, it would be a new wrinkle on that as far as I'm concerned.

This has always been my understanding of the term "Julian date".

This was definitely used on IBM AS/400s as the internal date storage
format in about 1990. I'm pretty sure, but not 100% positive, that it
was used on IBM S/38s which started in about 1979 or so.

(Actually AS/400s had a century field as well. 0 meant 1900 IIRC. A
little strange. <smile>)

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm