Management of the dimensions

[#1]

There is one  issue,

Sorry to disturb you too much .

I want to have two input fields of date type and I want to set the dimensions of the chart as the months between these two dates.

Example

(From Date) vfrm_dt= 2011-Jan

(To Date) vto_dt= 2011-Aug

Dimesion should be >. 2011-Jan,  2011-Feb, 2011-Mar,  2011-Apr, 2011-May,  2011-Jun, 2011-Jul,  2011-Aug

for the required chart.

Please help me out for the same.

I cannot get any expression which could give me the desired result.

Kindly also attach some example application to help me out.

[its_anandrjs]

Hi,

I want to know that the date field is two or it is single one it is a variable or what vfrm_dt, vto_dt  if it is a single one so you need to check this two condition DateField <= 2011_Jan and DateField >=2011_Aug. Then it will sort the data

Regards

Anand

[its_anandrjs]

Hi,

You need to check this date Start Date and End Date with variables and control your object with this variables like with this code

=If(Date>=vStartDate and Date<=vEndDate,Date)

Confirm it is two dates or single one.

Regards

Anand

[#4]

Dear Anandrjs.

Thanks you for your valuable time and valuable comment.

I would like to explain more as,

These are two varaibles

1. vfrm_dt , let it be 2011-JAN

2. vto_dt , let it be 2011-AUG

we have to get the months between these variables and put them as dimension.

i.e. Jan, feb,Mar,Apr,May,Jun,Jul,Aug

[its_anandrjs]

Hi,

Ok i under stand that see the attached sample file for clearity on that i manage two variable which holds vfrm_dt and vto_dt dates and manage the object in this condition with the code .

=If(Date>=vStartDate and Date<=vEndDate,date(Monthname(Date),'YYYY-MMM'))

See the attached sample for clearity.

Regards,

Anand