Export date field w/out time data

[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

 

[Bas Cost Budde]

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

 

[sming]

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,

 

[Bas Cost Budde]

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.