Date/time field changing seconds to all zeros

L

Laoballer

I have a two date/time field formatted in the general date field mm/dd/
yyyy hh:mm:ss AM/PM for the start of an event and for the end of an
event. I'm importing a csv file that's formatted in mm/dd/yyyy
hh:mm:ss (24 hr time). When I import the data the seconds gets lost
and all I get are zeros where the seconds should be in the access
table. What's going on that I'm losing the seconds data when
importing?

Thanks
 
J

Jeff Boyce

Look back over your description ...

You have "hh:mm:ss" and "mm/dd/yyyy" -- how's Access supposed to know what's
a "m"onth and what's a mi"n"ute?!

(hint: use "n" for minutes)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
L

Laoballer

Look back over your description ...

You have "hh:mm:ss" and "mm/dd/yyyy" -- how's Access supposed to know what's
a "m"onth and what's a mi"n"ute?!

(hint: use "n" for minutes)

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry, that was a typo I am using "n" for minutes. For example my
data is 04/29/2009 16:45:45 after importing it loses the seconds and
becomes 04/29/2009 02:45:00 PM

Thanks,
 
J

Jeff Boyce

Is that the actual value stored, or is that a 'formatted'/'displayed' value?

Remember that Access date/time fields store double-type numbers, with the
integer portion (left of decimal) representing the days since {some date
back in the late 1800's} and the decimal fraction portion (right of decimal)
representing portion-of-day. For example, a date/time value with x.5000
represents half a day, i.e., noon.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Look back over your description ...

You have "hh:mm:ss" and "mm/dd/yyyy" -- how's Access supposed to know
what's
a "m"onth and what's a mi"n"ute?!

(hint: use "n" for minutes)

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry, that was a typo I am using "n" for minutes. For example my
data is 04/29/2009 16:45:45 after importing it loses the seconds and
becomes 04/29/2009 02:45:00 PM

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top