Show month in report

[Akchayan]

Hello everyone,


I have in my report this code: = Month(Now()).
This code shows only the number of the month so, for example: September = 9.
But I want the report to show "September".


How can I do this?

[Welshgasman]

Look at the Format() function

[Akchayan]

if i put "mmmm" into the Format function it shows me January but i want the current month.

[Welshgasman]

So use the current date?
However Now() should work just as well?

? format(now(),"mmmm")
September

So I have no idea what your are using?

[ArviLaanemets]

OP is using the result of MONTH(Now()), i.e. in September it will be 9. And when OP uses this result with FORMAT, he/she formats 9th January 1900 as month, what of-course is returning "January"!

For OP: In Access and in Excel, dates are integers starting from 01.01.1900. Decimal parts of any date value are time values (hours, minutes and seconds) of this date. I.e. 1.5 is same as 01.01.1900 12:00, 2.75 is same as 02.01.1900 18:00, etc.

[davegri]

MonthName(Month(now))

will work without format function.

[Welshgasman]

MonthName(Month(now))

will work without format function.

Usually more than one way to skin the cat with computer programming.
Personally I would go with the option with the least functions.

[davegri]

Personally I would go with the option with the least functions.

A good route to take for sure.

[ArviLaanemets]

I haven't access to MS Office at moment to test it, but how about having a control on report with formula =NOW() as source, and the control formatted as "mmmm"?

[Micron]

Trying to imagine why I'd want this on a report that when I run it on 10/31/2022 the calc shows October, but I run the same report the next day and it shows November. - especially if the records contain a date. If the month info is for data, the date ought to be in the data, but I guess that doesn't matter here for some reason.

A control formatted as mmmm with source as Now() would work also.