Michael Dean
asked on
Convert Date value in Access
I have a field in a table where the date is stored as mm/dd/yyyy, i would like to convert the date in those fields to mm/yyyyy.
How can I do this?
How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
do I put that in a query or can I change the table values themselves?
BTW, when I said you can change the display format, I meant in the table design view. If you set the Format property on the General Tab of the Field Properties in table design view, the data will be displayed as mm/yyyy, but when you put your cursor in the field, it will display as the actual data.
If it is a date, you can change the display format of the date, but not the actual data itself. Or you could create a query based on that table that displays the date field in that format using the format function:
MonYr: Format([DateField], "mm/yyyy")