How to change date format

[MikeRT]

Hi,
I am new for database query. I am using Ms Access to store data. In Ms Access the date is in format of MM-DD-YYYY. I want to retrive that date in DD-MM-YYYY format. Can any body tell me how to convert this date format.
Thanks in advance.

Mike

[DanielaTm]

Hi,
Maybe you can use something like:

"SELECT (Format([Problem Management].[Date],"mmm"" '""yy")) AS Month,....."

[MikeRT]

Hi,
Maybe you can use something like:

"SELECT (Format([Problem Management].[Date],"mmm"" '""yy")) AS Month,....."


Hi,
Thanks for answer. It's working.