convert julian dates

[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?

 

[Douglas J. Steele]

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!)

 

[Guest]

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