Julian Date conversion within a query

J

Joe

The data extracts I work with are in Julian (2004214
equals August 2, 2004). I'm wondering if anyone has a
way to convert this number into a value that Access can
format as a date?

Thanks,
Joe
 
D

Douglas J. Steele

You sure about that? I make August 2, 2004 to be 2004215, not 2004214...

Try the following:
DateSerial([Julian]\1000, 1, ([Julian] - ([Julian]\1000)*1000)
 
G

Guest

Excellent! That worked.

Isn't the date I gave an example August 2nd? How does
Julian handle leap years?
-----Original Message-----
You sure about that? I make August 2, 2004 to be 2004215, not 2004214...

Try the following:
DateSerial([Julian]\1000, 1, ([Julian] - ([Julian]\1000) *1000)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



The data extracts I work with are in Julian (2004214
equals August 2, 2004). I'm wondering if anyone has a
way to convert this number into a value that Access can
format as a date?

Thanks,
Joe


.
 
G

Guest

And an explicit "thank you" for you.

Thank you.
-----Original Message-----
You sure about that? I make August 2, 2004 to be 2004215, not 2004214...

Try the following:
DateSerial([Julian]\1000, 1, ([Julian] - ([Julian]\1000) *1000)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



The data extracts I work with are in Julian (2004214
equals August 2, 2004). I'm wondering if anyone has a
way to convert this number into a value that Access can
format as a date?

Thanks,
Joe


.
 
D

Douglas J. Steele

March 1st, 2004 was 2004061. March 1st, 2005 will be 2004060.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Excellent! That worked.

Isn't the date I gave an example August 2nd? How does
Julian handle leap years?
-----Original Message-----
You sure about that? I make August 2, 2004 to be 2004215, not 2004214...

Try the following:
DateSerial([Julian]\1000, 1, ([Julian] - ([Julian]\1000) *1000)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



The data extracts I work with are in Julian (2004214
equals August 2, 2004). I'm wondering if anyone has a
way to convert this number into a value that Access can
format as a date?

Thanks,
Joe


.
 
D

Douglas J. Steele

That should, of course, read

March 1st, 2004 was 2004061. March 1st, 2005 will be 2005060.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Douglas J. Steele said:
March 1st, 2004 was 2004061. March 1st, 2005 will be 2004060.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Excellent! That worked.

Isn't the date I gave an example August 2nd? How does
Julian handle leap years?
-----Original Message-----
You sure about that? I make August 2, 2004 to be 2004215, not 2004214...

Try the following:
DateSerial([Julian]\1000, 1, ([Julian] - ([Julian]\1000) *1000)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



The data extracts I work with are in Julian (2004214
equals August 2, 2004). I'm wondering if anyone has a
way to convert this number into a value that Access can
format as a date?

Thanks,
Joe


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top