Abbreviated Month Names

2

Hi @Kelly_Claus :blush: !

Actually, the “MMM” or “MMMM” you can use in MonthName() is the 2nd and optional parameter you can place within the brackets of MonthName(), after the mandatory DateTime :blush: .

MonthName(dateTime, format)

E.g. : something like…

MonthName(Date(2021,11,29), "MMM")

… will return → Nov

or

MonthName(Date(2021,11,29), "MMMM")

… will return → November :blush: .

If you “chain” it you could have something like :

Date(2021,11,29).MonthName("MMM")

it would also return → Nov

The format in the documentation concerning this formula, is the format to use for this parameter in MonthName(). (and has nothing to do with Format() :blush: )

Now, concerning the specific formatting you want to use maybe this could help you :

Format(
  "{1}-{2:00}-{3}",
  thisRow.Date.Year().Right(2),
  thisRow.Date.Month(),
  thisRow.Date.MonthName("MMM")
)

Here is a quick simple, just to illustrate :blush:

5 Likes