Exporting Date Field to Text Files

  • Thread starter Thread starter Anthony Brock
  • Start date Start date
A

Anthony Brock

I am using Access 97 and cannot seem to get the date field
in my query to export in the format I want.

This solution (http://support.microsoft.com/default.aspx?
scid=kb;en-us;103174) did not work for me, or else I am
doing something wrong.

I simply want to be able to export the query's data to a
text file and I want the date field to be in the format
such as:

February 2, 2003.

Any one have a solution?
 
Anthony Brock said:
I am using Access 97 and cannot seem to get the date field
in my query to export in the format I want.

This solution (http://support.microsoft.com/default.aspx?
scid=kb;en-us;103174) did not work for me, or else I am
doing something wrong.

I simply want to be able to export the query's data to a
text file and I want the date field to be in the format
such as:

February 2, 2003.

Any one have a solution?
Click to expand...

Use the Format() function (not a format property).

MyDate: Format([DateField], "mmmm d, yyyy")
 
Back
Top