Julian to Gregorian date conversion

[Tommo]

how do I convert jualian date to gregorian and back in access 97, preferably
by not using VB Code if possible.

 

[ruralguy via AccessMonster.com]

What is the format of your Julian date and why the aversion to code?

 

[John W. Vinson]

how do I convert jualian date to gregorian and back in access 97, preferably
by not using VB Code if possible.

There are many kinds of Julian date: Astronomical Julian date, Modified
Astronomical Julian date, military Julian date, yyyyddd Julian date, ...

Which did you have in mind?


John W. Vinson [MVP]

 

[Tommo]

The date is entered as dd/mm/yy (Gregorian) and I want yyddd (Julian) to be
displayed. Secondly I want to reverse this process and display dd/mm/yy
(Gregorian) when data has been entered as yyddd (Julian). I realise in the
second process that I already have the data (dd/mm/yy G) but I am doing it
for educational purposes.

I have just discovered how to go from G to J in Forms by using an Unbound
Box using =Format([date],"yy") & Format(DatePart("y",[date]),"-000") in the
data control source. Data is entered in one field as G and displayed in
another as J.

 

[Douglas J. Steele]

You say your Julian date is yyddd, yet your formula implies it'll be yy-ddd.

Try:

DateSerial(Left([JDate], 2), 1, Right([JDate], 3))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The date is entered as dd/mm/yy (Gregorian) and I want yyddd (Julian) to
be
displayed. Secondly I want to reverse this process and display dd/mm/yy
(Gregorian) when data has been entered as yyddd (Julian). I realise in
the
second process that I already have the data (dd/mm/yy G) but I am doing it
for educational purposes.

I have just discovered how to go from G to J in Forms by using an Unbound
Box using =Format([date],"yy") & Format(DatePart("y",[date]),"-000") in
the
data control source. Data is entered in one field as G and displayed in
another as J.

There are many kinds of Julian date: Astronomical Julian date, Modified
Astronomical Julian date, military Julian date, yyyyddd Julian date, ...

Which did you have in mind?


John W. Vinson [MVP]