Remove time from exported data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
try:

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.
 
Back
Top