Date/time field changing seconds to all zeros

  • Thread starter Thread starter Laoballer
  • Start date Start date
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
 
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
 
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
Click to expand...

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,
 
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
Click to expand...

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,
 
Back
Top