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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Try

Format([FieldName],"mmyy")

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

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