Geek Answers Handbook

Get month name from number in Access database?

I am trying to figure out how to get the month name from a decimal digit in an access database.

I found this: Format(Date, "mmmm")unfortunately, I do not have a date, I have month numbers, so the function will not work.

is there any alternative i could use?

thank

+5
source share
3 answers

You can use the MonthName function (month) , available in MS-Access.

MonthName(3)            would return 'March'
MonthName(3, TRUE)      would return 'Mar'
MonthName(7, FALSE)     would return 'July'

In Access, the MonthName function returns a string representing the month specified by a number from 1 to 12.

The syntax of the MonthName function is:

MonthName ( number, [abbreviate] )

number is a value from 1 to 12 representing the month.

. : TRUE FALSE. TRUE, , . FALSE, .

! .

+6

MonthName, :

MonthName(11) November.

+2

Month of sales: Format(DatePart("m",[invoice date]),"mmmm")

Does this help, it extracts the full name of the month from the invoice date

+1
source

More articles:


All Articles