Format Date as Monthname

[Anonymous]

Hi there

Its so frustrating being a newbie sometimes. This seems so simple and yet...

I want to show these 2 dates as months (July and October) but when I use the function =Monthname([Reporting Date]) I get what is in the second image.

I'm loading the data from Excel and in Excel the date columns are formatted as dates

I must be missing something really simple?

[swuehl]

What do you see if you convert this chart to a table chart?

Do you see a Monthname?

If not, check that your default date format at the top of your script is set to 'DD/MM/YYYY'

see also

Why don’t my dates work?

Get the Dates Right

[swuehl]

And if you do see a Montname values in a table chart, then try creating the values in your script:

LOAD

     [Reporting Date],

     MonthName([Reporting Date]) as [Reporting Month],

     ...

and then use the new field in your chart.

[Anonymous]

Hi Stefan

Unfortunately that load script didn't work for me. The date format setting was correct and the text box you suggested, ended up being blank.

I think I found the solution... I had to create a simple calendar table and join that in to the main table.

I then use this expression in the chart and this worked for me.

=[Reporting Date-Last Day.autoCalendar.YearMonth]

Thanks for you help

Neil