Displaying month in long text

[jonbmorrison]

In a chart title I have been able to display the max date of data loaded

for example 7/31/2019

I have also been able to display Jul 2019 and Jul.

I want July - the full month name.   (so when September rolls around the title would show September not Sep)

variations of the following in my title expression

Month(MonthName(max([MonthEnd Date])))  - gives me Jul

MonthName(max([MonthEnd Date])) - give Jul 2019

and max([MonthEnd Date])  returns 7/31/2019.

I've tried some others without success - any thoughts welcomed.

[sunny_talwar · Accepted solution]

May be try this

Date(MonthName(Max([MonthEnd Date])), 'MMMM') will display July

Date(MonthName(Max([MonthEnd Date])), 'MMMM YYYY') will display July 2019