Dateformat in Chart (End of Month)

[#1]

Hey I have a chart with a month dimension which shows the following:

Jan Feb Mar Apr May Jun... etc.

Now, this chart is about the values at the end of the month. And i was thinking it would be more clear to change the dates to:

31/1 28/2 31/3 etc.

How can I change this in the chart?

[swuehl]

Maybe like this:

=Date(monthend(Date#('Jan','MMM')),'DD/MM')

replace 'Jan' with your Month field name.

I would probably create an additional field in the script, if possible, instead of a chart calculated dimension.

edit: And unless you also have Year information, too, above might give you wrong end of month for feb in leap years.

[#3]

I tried:

Day([Date]) &'/'& num(Month([Date]))                    as [DayMonth]

But I cant sort it in the chart.

[#4]

What would you recommend for leapyears? This works without leapyears.

Date(monthend(Date#(month([Date]),'MMM')),'DD/MM')                              as [DayMonth]