Date/Time Formatting

[NeilK]

I am trying to use the TransferText Export in Access but am having trouble getting the right formatting for a Date/Time column on one of my tables.

I am trying to get the date formatted for double digits ie. "05/09/03" and can get that by putting the "MM/DD/YYYY" criteria in the Format field, however, when I use the TransferText export function I get the Time in addition to the date. For example, "05/09/03 00:00:00". I only want the date to show.

Can anyone tell me how can I get rid of the time?

Thanks

Nk

 

[Ziggy]

This article should solve your problem, just make a Select query using all the fields in your table except the date. Follow the steps to put in a calculated field for date. Then just set the Macro to export the query.


http://support.microsoft.com/default.aspx?scid=kb;en-us;209268


Ziggy