convert julian dates

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

Guest

I have a data base with julian dates in several fields that I want to convert
to mm/dd/yyyy format. Is tahis possisable?
 
What's your definition of Julian Date?

If it's yyyyddd (where Jan 1 is 1, Jan 31 is 31, Feb 1 is 32 and so on until
Dec 31 is either 365 or 366, depending on whether it's a leap year or not),
then try:

DateSerial(Left([JulianDate], 4), 1, Right([JulianDate], 3))

(the reason I'm asking is because that's what most people call Julian Date,
but it's not. See http://en.wikipedia.org/wiki/Julian_date for what Julian
date really is!)
 
To convert a Julian date to a Normal Date in Access. Cut and paste into your
query. Change [Your Field Name] to the Julina date field name you have.

NormalDate: CDate(Format(((DateValue("01/01/"+LTrim(Str(1900+Int([Your Field
Name]/1000))))+[Your Field Name]-Int([Your Field
Name]/1000)*1000))-1,"mm-dd-yy"))


Please rate this if you find it helpful
 

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

Julian Date Question (Another) 4
converting julian Date to Database date 5
Moon phases and julian dates 0
Convert Date to Julian Date 2
How do I get the date to display a Julian date? (yyddd) 2
Julian Date Conversion 12
Julian date 5
convert Julian date to DD/MM/YYYY 7

Back
Top