Get month name

[Role21]

Hi,

 

I am using this formula to get the month in the specific Date field:
(DatePart(month, [@field:date]))
And the result of this formula is the number of the month but what I want is the month name for the result to display. 

 

Is there a way to do this? 

[JolliBeng]

Hi @Role21,

Yes, there's a way to do that. You just need to use the following formula on your calculated field:

(DATENAME(month, [@field:DATE]))

-JolliBeng

[DefinitelyNot31337]

Hi @Role21,

 

You may also just localize your date/time field on your DataPage to show the name of the month. See image below:

 

Regards,

DN31337!

[Kurumi]

Hi - I would like to add on this post. In case, you would like to get the month using DATEPART() and add leading zero, you may use these formulas:

RIGHT('0' + CAST(DATEPART(month, [@field:DATE]) AS VARCHAR(10)), 2)

or 

RIGHT('0' + CONVERT(VARCHAR(2), DATEPART(MM, [@field:DATE])), 2)

Result:

January = 1 to 01
February = 2 to 02

Since the DATEPART() function returns an integer, leading zero's will always disappear and need to be manually added like so.

Reference:
https://www.w3schools.com/sql/func_sqlserver_datepart.asp

[Kronos]

Hi,

You may also refer to this article for the available functions in getting the day and year from a Date/Time field:

Function Reference