how to convert julian date to calendar date in access 2003

D

Duane Hookom

If you want to ask a question and get an answer, please do as others have
done before you and use the big white space below the Subject to specify
what you have and what you need.

Try this expression
DateSerial( [JulianValue]\1000,1, [JulianValue] mod 1000)
 

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