Exporting Dates

[Joshann]

I have been reading all the posts I can on this topic. I see that it's a common problem, but I've tried all the suggestions and keep getting an error message. I am trying to strip out the time from a date field for exporting to a text file. I am using a select query. The name of the field is Date_Filed. I have tried changing the name in the design view of the query to NewDate:Format(DATE_FILED, "mm/dd/yyyy") and I get the following error message:
Compile error. in query expression 'Format(DATE_FILED, "mm/dd/yyyy")'.

I also tried changing the SQL statement to read SELECT Format(MyTable.DATE_FILED, "mm/dd/yyyy") As NewDate
FROM MyTable

I get the same error message as above. Does anyone know what I'm doing wrong?

 

[Joshann]

Nevermind. I quit Access, opened it up again, tried the exact same thing I mentioned above, and it worked. It must have been something left over from something else I was doing.