How to use format function in a query ?

[Hapr1]

HOw to use the format function . I had tried to use it but does not work for me .
when i click properties of the particular column in a query and go to format tab , i type in mm:dd:yy( i want to change the format of date ) and then execute the query but nothing happens.
can someone help me ?

 

[ejstefl]

Try picking "Short Date" from the drop down list.

 

[Hapr1]

When used short date it works in correct format in access but when
the macro runs and exports the file to excel it ges back to the same format like 17-jun-05.
Any ideas?

 

[ejstefl]

Pat,

I always have the same problem when exporting to Excel. Is there a way to keep the field in a Date format when you export to Excel, and have the format of the date kept as whatever it is in Access?

As an example, I have a date field in Access formated to short date. It has a value of 1/1/05. When I export to Excel, is there a way for Excel to display "1/1/05" while keeping it as a date type, instead of a text?