How can you format a date/time datatype to read month and year?

T

trainer07

For a field that has a date/time data type, how can I format (field
properties) the date so that it only shows month and year? In excel, I would
format the info using "mmyy". Is this the same in Access?
Thanks!
 
O

Ofer Cohen

Try

Format([FieldName],"mmyy")

Or
Format([FieldName],"mm/yy")

Check help on the function Format, there are few options
 
Top