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

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

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,
 
Jason said:
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,
Click to expand...

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