Change date from mm-dd-yyyy to MMM-YY in Access

[Vince]

How do I change a field which contains a date in a mm-dd-
yyyy format into mmm-yy format.
For Example: Ship Month = 03/01/2004
Convert "Ship Month" value to display "Mar-04"

 

[John Nurick]

Hi Vince,

Set the Format property of the field, and/or the control(s) that are
displaying it, to
"mmm-yy"

 

[Guest]

-----Original Message-----
How do I change a field which contains a date in a mm-dd-
yyyy format into mmm-yy format.
For Example: Ship Month = 03/01/2004
Convert "Ship Month" value to display "Mar-04"
.
hello,

simply goto Start--->setting-->control penal-->regional
setting and chane the date format from there. I will
automatically change the date formate for msaccess.
Anis Ahmed

 

[Joan Wild]

simply goto Start--->setting-->control penal-->regional
setting and chane the date format from there. I will
automatically change the date formate for msaccess.

....and every other program. Just set the format for the field to mmm-yy.
Better yet, set the format on controls bound to this field.