Julian Date conversion within a query

  • Thread starter Thread starter Joe
  • Start date Start date
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
 
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)
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...


.
Click to expand...
Click to expand...
 
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


.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top