how can i convert a julian date into a date recognised by Access

J

John Vinson

Please post your questions as questions. It makes it easier.

The answer depends on what you mean by "Julian date"; that term is
used for MANY different kinds of formats, such as the astronomical
julian date, the modified astronomical julian date, the military date
(last digit of the year and three day digits), yyddd, and so on and so
on.

Usually you'll have some sort of a year and some sort of a day; if
it's the fairly common yyyyddd type, try

DateSerial(Left([JDate], 4), 1, Val(Right([JDate], 3)))

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

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

Similar Threads

How do I get the date to display a Julian date? (yyddd) 2
how do I convert a julian date(JDEdwards) into a calendar date 4
How to Convert a Julian Date to Calendar Date 2
How do I convert from a julian date to a standard date mm/dd/yyy 3
How do i convert a regular date to a julian date in a query 2
How do I convert a Julian date into a regular date? 4
letter 1
How can I create an accountable employee attendance program? 0

Top