format just the month and two digit year

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

Guest

Hopefully, this is a simple request. What do I type in the query (field) to
get only the Month and year. MMMYY. Three digit month and two digit year.

Thank you very much.
 
Hopefully, this is a simple request. What do I type in the query (field) to
get only the Month and year. MMMYY. Three digit month and two digit year.

Thank you very much.
Click to expand...

From a valid Date datatype field?
MonthYear:Format([DateField],"mmmyy")
 
PERFECT!!!!

Thanks!
--
Gina


fredg said:
Hopefully, this is a simple request. What do I type in the query (field) to
get only the Month and year. MMMYY. Three digit month and two digit year.

Thank you very much.
Click to expand...

From a valid Date datatype field?
MonthYear:Format([DateField],"mmmyy")
Click to expand...
 
You must log in or register to reply here.

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

Access 2 Digit year in Access Text Box 3
Query criteria 4
Looking for help eith VBA string manipulation 2
Calculate Years of Service 11
2 digit year 8
Sorting by month field 1
Unique field 3
Two digit dates and two digit days 3

Back
Top