Exporting Date Fields

[Tom]

Hi All,

I have a problems exporting a date field in a query. I
have specified the format, which is mmm,dd,yyyy in the
corresponding table field, and when I look at the query
this is how the dates are displayed. However, when I
export the query (I need to export it to a csv file), the
field is changing itself to dd,mm,yyyy with 00:00:00
after the date. How do I get round this to export the
information in the format I have specified above?

Thanks in advance for any help!

Tom

 

[Joan Wild]

In your query change the datefield column to
Format([DateField],"mmm,dd,yyyy")