By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,656 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,656 IT Pros & Developers. It's quick & easy.

Julian Date Conversion - Can Anyone Help?

P: n/a
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
Feb 24 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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)
Feb 24 '06 #2

P: n/a
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

Feb 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.