convert julian date in access

[Guest]

I would like to find a method to convert a julian date to a regular calender
date in access

 

[Marshall Barton]

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.

 

[Randy]

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

 

[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