Exporting date data

[Big Time]

I'm exporting a large amount of data from one of my tables into a tab
delimited text file. The problem is the fields that have date format come
out in MM/DD/YY HH:MM:SS format when what I want is to have the dates come
out simply as MMM/YY i.e. Jan / 04 instead of 1/1/04 00:00:00 . I have
tried using export specs to get this to work but there is no option to drop
the DD and have it export simply as Jan/04. Is there any way around this?

[Reggie]

Big Time, Design a query based on the table you want to export.
Right-click in your date field and select properties. On the format line
type in mmm/yy. In your spec use the query to export instead of the table.

--
Reggie

----------
"Big Time" <bi************@remove-for-spam-hotmail.com> wrote in message
news:ce**********@lettuce.bcit.ca...

I'm exporting a large amount of data from one of my tables into a tab
delimited text file. The problem is the fields that have date format come
out in MM/DD/YY HH:MM:SS format when what I want is to have the dates come out simply as MMM/YY i.e. Jan / 04 instead of 1/1/04 00:00:00 . I have
tried using export specs to get this to work but there is no option to drop the DD and have it export simply as Jan/04. Is there any way around this?