When you export date fields to text, the time format is included Abstract

There are two methods to work around this behavior.

Method 1

Create a query that has a calculated field to format the Date/Time field appropriately, and then export the results of the query. To do so, follow these steps

1. Open the sample database Northwind.mdb.
   
2. Create the following new table in Design view:

   
      Table: TestDate
      --------------------
      Field Name: Birthday
      Data Type: Date/Time
    

3. Save the table, and then close it. You do not have to create a primary key.
   
4. Open the table in Datasheet view, add the following record, and then close the table:

   
      04/19/93
    

5. Create the following new query based on the TestDate table:
   
   

   
      Query: ExportDates
      ------------------------------------------------
      Type: Select Query
   
      Field: Birthday2: Format([Birthday], "mm/dd/yy")
    

   NOTE: The calculated field name cannot match the name of any other field that is included in the query.
   
6. Save the query, and then close it.
   
7. Export the query.
   

Method 2

You can have Access create a fixed-width text file by using the "Text (Fixed Width)" export format. By using this method, you can set the size of the Date/Time field to 10 characters in the Export Specification dialog box. This will truncate the time portion of the Date/Time field when the file is exported.


NOTE: This method assumes that you have the Four Digit Years and Leading Zeroes in Dates options selected in the Export Specification dialog box.


NOTE: Most common text exports require the data is delimited by using the Text (Delimited) format. Method 2 is not useful in these cases.