Date Problem

[JD McLeod]

I have a table of data that I am importing in from another software program
(Creative Solutions - Go System). The other program is an accounting trial
balance system. The data comes over fine, except for the date. Access is
storing the date as a number with the format of a long integer. I can't seem
to be able to get that number converted back to a date. Changing the format
doesn't work. Does access stores dates as numbers? Any help would be
greatly appreciated.

 

[Ken Snell [MVP]]

ACCESS stores dates as a floating point number: the integer portion is the
number of days since December 30, 1899; and the decimal portion is the
fraction of a 24-hour day represented by the time.

So the answer to your question "Does access stores dates as numbers?" is
yes.

To assist us with assisting you, a few questions....how are you importing
the data file? What is the actual content of that file for the date value?

 

[Brendan Reynolds]

Access stores dates using the Double data type, with the whole part of the
number representing the number of days since 30 December 1899, and the
fractional part representing the time as a fraction of a 24 hour day, e.g.
..25 is 6am, .5 is 12 noon, and .75 is 6pm.

Now what you need to know, in order to convert those imported numbers into
dates, is how does the *other* program store dates?