View Single Post
  #1  
Old October 29th, 2008, 11:23 PM posted to microsoft.public.access
Misty
external usenet poster
 
Posts: 34
Default Date & time Data Type formatting

I'm not sure what caused the problem but my date fields in my table now have
a time of 00:00:00 saved with them. ie. I enter 10/18/2008 and when the data
exports into text it reads "10/18/2008 00:00:00" for the field data. I have
the formating set to Long Date. How do I get rid of the zero timestamp? I can
deal with the short date format I think but how do I make the time go away -
I have no idea where it is even stored at but I think it has to do with the
default formatting for Data Type.

Thanks!