Change Date to Month

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hello,

I am using Access 2000. I have a field on a report that returns a date 10/08/04 which is based on a query. Is there a way to have the field display only as the name of the month in this report? For example: If employee 2 on this report has the date 10/23/04, I want this field to also show as the word October. If employee 3 has the date 10/20/04 I want it to be October as well. If employee 4 has a date of 4/20/04, I want it to return April for this field (maybe it's called a control?).

Thanks,
Linda
 
Go to properties for the field you want to change and type "mmmm" without the quotes in the format field. This should change any date to its' appropriate written month.
Hello,

I am using Access 2000. I have a field on a report that returns a date 10/08/04 which is based on a query. Is there a way to have the field display only as the name of the month in this report? For example: If employee 2 on this report has the date 10/23/04, I want this field to also show as the word October. If employee 3 has the date 10/20/04 I want it to be October as well. If employee 4 has a date of 4/20/04, I want it to return April for this field (maybe it's called a control?).

Thanks,
Linda
 
Thanks so much!

Linda
Go to properties for the field you want to change and type "mmmm" without the quotes in the format field. This should change any date to its' appropriate written month.
Hello,

I am using Access 2000. I have a field on a report that returns a date 10/08/04 which is based on a query. Is there a way to have the field display only as the name of the month in this report? For example: If employee 2 on this report has the date 10/23/04, I want this field to also show as the word October. If employee 3 has the date 10/20/04 I want it to be October as well. If employee 4 has a date of 4/20/04, I want it to return April for this field (maybe it's called a control?).

Thanks,
Linda
 
In either the query or in a textbox on the report use format$(yourdate,"mmmm").

HTH
Martin
 
Hi Martin,

What does format$ mean? The solution from PizzaBoy worked so far but I would like to know the difference in the 2 solutions.

Thanks,
Linda
In either the query or in a textbox on the report use format$(yourdate,"mmmm").

HTH
Martin
 
His solution is the easiest to use so use it.

Martin

FYI, Format(...) or format$(...) is the function the report uses in format
property to convert your date to a month.
 
Back
Top