How do I get the time out of a date field?

[Guest]

I'm trying to export a table from Access into a text file. Everytime I export
the table, all the date fields that I exported have a time format in them.
How do I get the time not to export with the date fields? In the design view
of the table, all the date fields are Data/Type - Date/Time, with the format
of short date?
Thanks,

 

[Rick Brandt]

I'm trying to export a table from Access into a text file. Everytime
I export the table, all the date fields that I exported have a time
format in them. How do I get the time not to export with the date
fields? In the design view of the table, all the date fields are
Data/Type - Date/Time, with the format of short date?
Thanks,

You have to use the Format() function (not the format property) in a query
and export the query instead of the table.