HELP FORMATTING DATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I am new to this discussion group. My question is how do I format date and
time in my table. I import my spreadsheet and the data is fine, but
afterwards when I go back into the table that houses the info I just imported
it converted my dates and times as numbers and decimals.

Any suggestions???? I am going crazy trying to figure it out.

Help
 
Hello

I am new to this discussion group. My question is how do I format date and
time in my table. I import my spreadsheet and the data is fine, but
afterwards when I go back into the table that houses the info I just imported
it converted my dates and times as numbers and decimals.

Any suggestions???? I am going crazy trying to figure it out.

Help
Click to expand...

Most likely the date is correct.
The current date and time (as I write this reply) is stored as
39208.9463888889
which is formatted to:
5/6/2007 10:42:48 PM

All you need do is give it a valid date/time format.
As the field's Format property, write:
General Date
or
mm/dd/yyyy hh:nn:ss
or
any other valid date format.

Note: It really is irrelevant how the date value is actually stored in
the table, and you should not be looking at data in your table anyway.
Use a form.
 
And if you keep importing it into the same table over and over again I would
recommend changes the datatype in the table to a datetime-type. If it is a
single process I would follow Freds advice...

Maurice
 
Do I change the format in the spreadsheeet before I import it?
Click to expand...

It should make NO DIFFERENCE.

Data storage and data presentation are two different things. A Date/Time value
is *stored* in Access or in Excel as a number - a count of days and fractions
of a day since an arbitrary start point. You can *display* it using any
desired date format; that doesn't affect what's stored in the table, or the
spreadsheet.

John W. Vinson [MVP]
 
Back
Top