Menu
I am trying to figure out how to get month name from a month digit in access database.
I found this: Format(Date, "mmmm"), unfortunately i don't have the date, all i have are the months numbers so that function won't work.
is there an alternative i could use?
Thank you
938
The Month() function returns the month part for a given date. This function returns an integer between 1 and 12.
On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Type an expression in the Field row in the first column. For example, to sort by month regardless of the year, type the expression Expr1: DatePart("m",[BirthDate]) in the Field row in the first column.
Returns a Variant (Date) specifying the current date and time according your computer's system date and time.
You can use the MonthName(Month) function 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 given a number from 1 to 12.
The syntax for the MonthName function is:
MonthName ( number, [abbreviate] )
number is a value from 1 to 12, representing the month.
abbreviate is optional. This parameter accepts a boolean value, either TRUE or FALSE. If this parameter is set to TRUE, it means that the month name is abbreviated. If this parameter is set to FALSE, the month name is not abbreviated.
Hope! this will help you.
57
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
