If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Date & time Data Type formatting
On Wed, 29 Oct 2008 16:23:01 -0700, Misty
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|