Date & time Data Type formatting

[Misty]

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!

 

[John W. Vinson]

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!

Regardless of the formatting, a Date/Time value always has a time (midnight if
you don't specify it); it's stored internally as a number, a count of days and
fractions of a day since midnight, 12/30/1899.

Exporting will always export the full value (with the time), again regardless
of formatting.

To export just the date, put a calculated field in the query:

ExpDate: Format([datefield], "Short Date")

and export the query rather than the table.