How to change date format
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
[270 byte] By [
MikeRT] at [2007-11-19 22:42:47]
# 1 Re: How to change date format
Hi,
Maybe you can use something like:
"SELECT (Format([Problem Management].[Date],"mmm"" '""yy")) AS Month,...."
# 2 Re: How to change date format
Hi,
Maybe you can use something like:
"SELECT (Format([Problem Management].[Date],"mmm"" '""yy")) AS Month,...."
Hi,
Thanks for answer. It's working.
MikeRT at 2007-11-9 13:44:45 >
