Forum Discussion
Arabic months name
Hi pbiadenhostacc ,
I'm sorry that the formula I gave is wrong.
The reason for the error is because FORMAT returns a text format, and the SWITCH below judges that the 1 in Month_Name = 1 is a number type.
This is the new calculated column I tested.
Column = VAR Month_Name = FORMAT ( [Date], "mm" ) RETURN SWITCH ( TRUE (), Month_Name = "01", "كانون الثاني", Month_Name = "02", "شهر فبراير", Month_Name = "03", "مارس", Month_Name = "04", "أبريل", Month_Name = "05", "مايو", Month_Name = "06", "يونيو", Month_Name = "07", "يوليو", Month_Name = "08", "أغسطس", Month_Name = "09", "سبتمبر", Month_Name = "10", "اكتوبر", Month_Name = "11", "شهر نوفمبر", Month_Name = "12", "ديسمبر" )You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi pbiadenhostacc ,
I'm sorry that the formula I gave is wrong.
The reason for the error is because FORMAT returns a text format, and the SWITCH below judges that the 1 in Month_Name = 1 is a number type.
This is the new calculated column I tested.
Column =
VAR Month_Name =
FORMAT ( [Date], "mm" )
RETURN
SWITCH (
TRUE (),
Month_Name = "01", "كانون الثاني",
Month_Name = "02", "شهر فبراير",
Month_Name = "03", "مارس",
Month_Name = "04", "أبريل",
Month_Name = "05", "مايو",
Month_Name = "06", "يونيو",
Month_Name = "07", "يوليو",
Month_Name = "08", "أغسطس",
Month_Name = "09", "سبتمبر",
Month_Name = "10", "اكتوبر",
Month_Name = "11", "شهر نوفمبر",
Month_Name = "12", "ديسمبر"
)
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous I wonder if there is another way using the format function only?
Like this one in Excel that uses some encoding to return the month name in Arabic letters directly
=TEXT(today(),"[$-0401]mmmm")