Remove time from exported data



I've read the posts on removing the time from exported data (.csv format) and
nothing has worked for me. I am using a query to export the data, but when I

DateOnly: Format ([Date], "mm/dd/yyyy")

in the "Field" part of the query, I get a blank doc. Also, should it be
calling on a table because when I fill in "Table" I receive an error.

Thank you.


What do you mean about the Table part? I don't quite understand. As to
stripping out the time, you may try:
DateOnly: DateValue([Date])

BTW, You should not use Date as a field name. Even when bracketed, it can
cause problems. Date, Name, Time, or any other Access reserved word should
not be a user named object in Access.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question