Date to show only the month

  • Thread starter Thread starter Dennis Villareal
  • Start date Start date
D

Dennis Villareal

I am trying to make a report that shows the production of a month. we enter
all the data in the table as a standard date. 2/1/09 like that. i want the
query to display only the Month Number like 2.

how can i accomplish this?

as a added bonus how can i get the Display to show the actual month

like if 2 show Feb. this will help make the reports look nicer.

thanks
 
I am trying to make a report that shows the production of a month. we
enter all the data in the table as a standard date. 2/1/09 like that.
i want the query to display only the Month Number like 2.

how can i accomplish this?

as a added bonus how can i get the Display to show the actual month

like if 2 show Feb. this will help make the reports look nicer.

thanks
Click to expand...

For the number of the month you can use either...

=Month(FeildName)
or
=Format(FieldName, "mm")

For the month name...

=Format(FieldName, "mmmm")
 
I am trying to make a report that shows the production of a month. we enter
all the data in the table as a standard date. 2/1/09 like that. i want the
query to display only the Month Number like 2.

how can i accomplish this?

as a added bonus how can i get the Display to show the actual month

like if 2 show Feb. this will help make the reports look nicer.

thanks
Click to expand...

Simply bind the date field to a textbox on the report; set the Format property
of that textbox to "m" to show 2, "mm" to show 02, "mmm" to show Feb, and
"mmmm" to show February. You're NOT limited to the predefined "canned" date
formats!
 
thanks this worked great

Rick Brandt said:
For the number of the month you can use either...

=Month(FeildName)
or
=Format(FieldName, "mm")

For the month name...

=Format(FieldName, "mmmm")
Click to expand...
 
Back
Top