AMPScript DatePart(D1, S1): how to retrieve month name?

Question

The definition for the AMPScript DatePart(D1, S1) function is missing the argument for month name. It reads as follows:

"S1 The part of the date to retrieve. Valid values include year (Y), month (M), monthname, day (D), hour (H), and minute "

Does anyone Know how to retrieve month name?

Answer 1

If you just want the month name, you can use the Format() function

%%[

var @date1 
set @date1 = Format(Now(), "MMMM")

]%%    
%%=v(@date1)=%%

Output

January

Reference: AMPScript Date and Time Formatting

Answer 2

You can also use the FormatDate() function. This functions accepts a few additional parameters and is particularly useful when you need to return the month in a different language.

%%=FormatDate(Now(), "MMMM",,"es-ES")=%%    /* -- January -- */

Output

enero

tips: The 3rd parameter is for formatting the time. If no time formatting is needed, pass an null value for this parameter. Also, insure the culture code in the 4th parameter is valid. If an invalid string is passed, it could cause a run-time error.

Answer 3

Here are the accepted values for the second parameter of the DatePart() function (case insensitive):
y, m, d, h, mi, year, month, monthname, day, hour, minute