What is the syntax to return the month’s name from date?

MonthName(month, toabbreviate)
‘month can be values 1-12; mandatory parameter
‘toabbreviate can be true or false; optional parameter that defaults to false
‘examples
MsgBox (MonthName(1, True)) 'returns Jan
MsgBox (MonthName(1)) 'returns January
MsgBox (MonthName(12, False)) 'returns December

 

Advertisements