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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MM/DD date format no year 5
Excel Vba to change displayed year automatically. 14
Date/Time to Display only Month 7
Access 2 Digit year in Access Text Box 3
Month/Year Format 3
Inserting Default Month and Year 1
Sorting by Month and Year in Query 2
Properties - Format, Input Mask, Validation Rule 5

Back
Top