G
Guest
I would like to find a method to convert a julian date to a regular calender
date in access
date in access
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marshall Barton
JayG. said:I would like to find a method to convert a julian date to a regular calender
date in access
How about you tell us what yout mean by Julian date and
provide a couple of examples.
R
Randy
JayG. said:I would like to find a method to convert a julian date to a regular
calender
date in access
Jay, you can use any of the following calculations. Please remember that
Julian dates are only valid within a specific year.
This formula will use the current year:
Cdate(dateserial(year(now()),1,1) + [Julian Date] - 1)
This other formula will use a given specific year:
Cdate(dateserial([Year],1,1) + [Julian Date] - 1)
-Randy
J
John Vinson
I would like to find a method to convert a julian date to a regular calender
date in access
The term "Julian date" is ambiguous. DO you mean the Astronomical
Julian Date, the Modified Astronomical Julian Date, the military date
code based on the last digit of the year plus the day number, yyyyddd,
yyddd, ...?
All of these can be converted but they will require different logic.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps