Exporting Date Field to Text Files

[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?

 

[Rick Brandt]

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?

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

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