1 of 1 people found this helpful
There are several ways to get the month from a date field. Seeing the data it seems string values. You've to first convert these values to datetime then you can easily get the month name out of that.
If your datetime field contains string values then below is my approach,
Create a calculated field like this
DATEPARSE("dd.MM.yyyy hh:ss",[Datetime]) //It will convert the string into date and time. "dd.MM.yyyy hh:ss" set the format as per your requirement.
DATENAME('month',DATEPARSE("dd.MM.yyyy hh:ss",[Datetime])) //It will fetch the month name from that string
Let us know if this help.