Julian to Gregorian date conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do I convert jualian date to gregorian and back in access 97, preferably
by not using VB Code if possible.
 
What is the format of your Julian date and why the aversion to code?
 
how do I convert jualian date to gregorian and back in access 97, preferably
by not using VB Code if possible.
Click to expand...

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]
 
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.
 
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!)


Tommo said:
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.

John W. Vinson said:
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]
Click to expand...
Click to expand...
 
Back
Top