Date format in table exported to tab delimited file

[kaizenkk]

Hi,

I have a table which contains date fields. When the date fields are exported to a tab delimited text file they need to be in short date format i.e. (12/19/2011) without the time. I have set both the date format in the table to short date as well as the input mask as short date in the field list in design view. When I view the table there is no time displayed, only the short date format (12/19/2011). However, when I export the table to a tab delimited text file, the date comes with the time of 00:00 (12/19/2011 00:00). Can you please help me figure out how to remove this blank 00:00 time in the exported text file?

Thanks,
Karen

 

[pbaldy]

Try using the Format() function when you export (in a query):

Format(FieldName, "Short Date")

or the custom format of your choice.