Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this
Date(MonthName(Max([MonthEnd Date])), 'MMMM') will display July
Date(MonthName(Max([MonthEnd Date])), 'MMMM YYYY') will display July 2019
May be try this
Date(MonthName(Max([MonthEnd Date])), 'MMMM') will display July
Date(MonthName(Max([MonthEnd Date])), 'MMMM YYYY') will display July 2019