Julian Date conversion 2

[Jennpen1]

I have data that has dates in the Julian format:

3032 = 32nd day in 2003 = February 1, 2003
99002 = 2nd day in 1999 = January 2, 1999

I would like to break it up into the standard date format, MMDDYYYY.

I have been trying to accomplish this task by several If SQL statements but it they are becoming very long and tedious. Does anyone know if Access has any type of built in cpability that would make converting from a Julian date any easier??

 

[PHV]

Have you tried something like this ?
DateSerial(yourJulianDate\1000, 1, Right(yourJulianDate,3))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Jennpen1]

That works perfectly. Thank you so much for your help!!!!