Export date field w/out time data

  • Thread starter Thread starter Sming
  • Start date Start date
S

Sming

Hi,


For some reasons, if I export a file into comma delimited
format, it includes the 00:00:00 hours and minutes at the
end of date field even though I specify on the table
design to mmddyyyy only.

Any ideas to fix the export specification to limit the
date field to dates and no time?

Thanks a bunch!!!

Sming
 
Sming said:
Hi,


For some reasons, if I export a file into comma delimited
format, it includes the 00:00:00 hours and minutes at the
end of date field even though I specify on the table
design to mmddyyyy only.

Any ideas to fix the export specification to limit the
date field to dates and no time?

Create a query on the table that does either DatePart(yourdatefield) or
Int(yourdatefield) and export that query
 
HI,

Thank you for your suggestion.

If I do the Datepart, does that mean I have to break
mmddyyyy into 3 fields and set the field format to
numeric? How do you export a query? I created a
MakeTable query.

Thanks,
 
sming said:
HI,

Thank you for your suggestion.

If I do the Datepart, does that mean I have to break
mmddyyyy into 3 fields and set the field format to
numeric?

No, I must have misread that. If your field is text already, and the
characters just mean month, day and year to *us*, I can't see why a time
would be added.
How do you export a query? I created a MakeTable query.

Clever. But do you export via TransferText? For the tablename argument,
a query is as valid as a table.
 
Back
Top