Changing Date to Just month and Year

  • Thread starter Thread starter Bryce
  • Start date Start date
B

Bryce

I have a field that contains dates. I only want the
report to show the month and year. Can i do this on an
input mask? Thanks in advance for any help.

example. Field has 12/31/2003, and I want December 2003
 
Use Format.

=Format([DateField], "mmmm yyyy") for the control source
or, in the Format tab set the Format option to
mmmm yyyy

The first option won't work if the textbox has the same name as the field.
If it does change the name of the textbox to txtDateField. Make sure that
"auto correct" doesn't change the name of the field in the entry when you
change the name of the textbox.
 

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

Back
Top