Create a Julian Date routine

[c5665]

Hi,

My question is, how do you take the current date and convert it into a Julian Date format using MSAcess, or I should say VBA coding.

 

[psemianonymous]

http://www.google.com/search?hl=en&q=julian+date+vba

 

[cghoga]

Create a table called daylkup having 2 fields. One for normal date format and the other for its corresponding julian day.

Populate the table with year round dates including Feb 29 for leap year.

Like below:

01/01/2004 001
01/02/2004 002

Than, use relations to set the juian day values.

Relate the current date to its match in the table and display the julian day based on the relation.

Hope this helps.

 

[CajunCenturion]

First of all, you need to let us know what you mean by Julian Date. Do you mean the

True Julian Date, which starts on Noon (12:00 on January 1, -4713,

Modified Julian Date, which starts at Midnight on November 17, 1858, or

Comtemporary Accepted Julian Date, (contemporary accepted is my term, because this is not truly a Julian date) which is a five digit number with the first two digits representing the year, and the next three for the day within the year?


Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein