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 2 3558
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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
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 ConvertJulianDa te(strJulianDat e As String) As Date
Dim strTempDate As String
strTempDate = Replace(strJuli anDate, "0", "", , , vbTextCompare)
ConvertJulianDa te = Format(strTempD ate, "mm/dd/yyyy")
End Function
"No Spam" <no****@earthli nk.net> wrote in message
news:oo******** *************** *********@4ax.c om... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: goochey |
last post by:
I'm trying to convert a Julian Date (Format "4365") into an actual calendar
date in Visual Basic, can anyone help me out with this.
|
by: sunny076 |
last post by:
Hi,
I am trying to convert from Julian to Gregorian data in C#. I was
exploring teh JulianCalendar and Gregorian calendar classes but still
not sure how I can do it. For example, the Julian date is 100033 and I
know that it is 2/2/2000 in Gregorian.
I would appreciate if anyone can help point me out.
|
by: Chris Davoli |
last post by:
Is there a class that converts from Gregorian date to TRUE Julian Date in
..NET? Any VB.NET examples available?
ie;
The Julian date is calculated by the number of days since January 1, 4713
BC. For example, the Julian date for August 1, 2001 is 2452122.
--
Chris Davoli
|
by: Karl O. Pinc |
last post by:
Hi,
What's the best way to obtain the Julian day from a postgresql
date?
PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
I'm doing some date arithmetic with 1 day intervals and want
to, for example, round to the even Julian day. I suppose
|
by: simchajoy2000 |
last post by:
Hi,
I am reading some dates from an Excel worksheet in my VB.NET code and
even though in Excel these dates appear in this format 3/18/04, it is
read into my code as a number like this: 36903.
I have been told this is a Julian date but the calculations I have
found on the internet to handle the conversion gives me dates from 1938
- so either this isn't a Julian number or excel has it's own way of
calculating it.
| |
by: Bit byte |
last post by:
How may I represent dates as Julian dates - I have seen code where
julian dates are represented as longs, and other where they are
represented as floats. Which is the correct representation?
Anyone knows where I can obtain a routine for converting:
1). Dates to/from julian representations
2). Date/time values to/from Julian representations
|
by: pdavis06 |
last post by:
I know that there is a thread about this, but I was unable to add to it; I just joined. The problem is that I do not want to change the date format for the entire database output, merely for a header on a report and for a field on that report.
I thought that I could just go into the expression builder and paste one of the codes that were posted in the thread about this conversion-you'll know that did not work.
So, I went to the new...
|
by: IsdWeb |
last post by:
Hello,
I am a newbie to coding and need some help. I am trying to figure out
why the following code is not producing the correct Julian date. Any
suggestions? Also, I am trying to understand the syntax liek what
does DateAdd mean? If anyone can offer some good tutorials it would
be appreciated as well.
Thanks in advance.
|
by: =?Utf-8?B?VmljdG9y?= |
last post by:
Hi,
How can I conver Julian date to a 'standard' DateTime?
So 2449810 will be converted to 1995/4/2.
Thanks.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |