Julian Date Conversion - Can Anyone Help?

[No Spam]

Dear Access 2003 Users,

I have been given an Excel 2003 spreadsheet with thousands of records,
and I need to bring it into Access 2003. Does anyone know an Access
formula that can convert these dates to "normal" dates?

These are some examples of the dates that were sent to us:

738220000
629420000
407007000

Thanks a million in advance!

Kevin

[MGFoster]

No Spam wrote:

Dear Access 2003 Users,

I have been given an Excel 2003 spreadsheet with thousands of records,
and I need to bring it into Access 2003. Does anyone know an Access
formula that can convert these dates to "normal" dates?

These are some examples of the dates that were sent to us:

738220000
629420000
407007000

Depends... The "real" (astronomy) definition of a Julian date is the
number of days since noon, January 1, 4713 BC. Others define it as the
year w/ the number of days since Jan 1 of that year: 2006055 - the 55th
day of the year 2006 (Feb 25, 2006). What's the start date of your
"Julian" dates?

The astronomical Julian date is 2453790.5.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Darren Wallace]

If I'm reading the dates correctly, the following function should convert
them to the correct date format. You may want to create a new field in the
underlying table and Run and Update Query calling this function

Public Function ConvertJulianDate(strJulianDate As String) As Date

Dim strTempDate As String
strTempDate = Replace(strJulianDate, "0", "", , , vbTextCompare)
ConvertJulianDate = Format(strTempDate, "mm/dd/yyyy")
End Function

"No Spam" <no****@earthlink.net> wrote in message
news:oo********************************@4ax.com...

Dear Access 2003 Users,

I have been given an Excel 2003 spreadsheet with thousands of records,
and I need to bring it into Access 2003. Does anyone know an Access
formula that can convert these dates to "normal" dates?

These are some examples of the dates that were sent to us:

738220000
629420000
407007000

Thanks a million in advance!

Kevin