Days in Selected month as chart dimension

[#1]

I've got a bar chart, and listbox with months. And I want to create dimension with days of selected month. Any idea to approach this?

To be clear :

Select month from listbox, and bar chart dimension would be the days in that months. If I select Feb, there should be 29 or 28 days. etc...

[sunny_talwar]

May be do something like this:

=Floor(MonthEnd(DateField)) - Floor(MonthStart(DateField)) + 1

[jonathandienst]

Its best to create the Day field in the load script when you load the rest of the calendar:

     LOAD

          ...

          tDate,

          Year(tDate) As Year,

          Month(tDate) As Month,

          Day(tDate) As Day,          // day of month

          ...

If you cannot change the script, then use this as a calculated dimension:

         =Day(tDate)

(Change "tDate" to the correct field name for your application)

[sasiparupudi1]

day(MonthEnd(Today()))

replace Today() with your date field

hth

Sasi