Showing the range of dates selected in current selection box

[Anonymous]

Hi

How do i display the complete format of a date field , when user selects a range of dates , for example a user selects 01/01/2010 - 02/01/2011, the current selection box display something like 30 of 2345 , instead can i display

01/01/2010 - 02/01/2011 , so that user know what date range has been selected.

Or, please suggest any other way to achive this other than showing in a calender box?

Thank you

[Anonymous]

Thank you Rocky ,

I see the expression =Min ({1}DAY_DATE) what does that mean?

[boorgura]

when you just say min(day_date),

you limit the values to the possible values - meaning - if 10 dates are selected, but the total dates 100,

using min({1} day_date) will give the option for all 100 dates.

{1} is the set analysis modifier to ignore all selections.

[Anonymous]

Some how these conditions not working for my expression :

i have multiple chart with different expression now i have to mimic the day_date condition for all my expressions ..

here are my expression :

sum({<OPERATION_NAME*={'ENGINEERING'}>} USED_HOURS)/sum(AVAILABLE_HOURS)

sum({<HOUR_SEG_PRIME*={'AM-Eng:7 AM - 9 AM'}>} USED_HOURS)

I tried which does not work..:-(

=if(DAY_DATE >= '$(From)' and DAY_DATE <= '$(To)',sum({<OPERATION_NAME*={'ENGINEERING'}>} USED_HOURS)/sum(AVAILABLE_HOURS))

=if(DAY_DATE >= '$(From)' and DAY_DATE <= '$(To)',sum({<HOUR_SEG_PRIME*={'AM-Eng:7 AM - 9 AM'}>} USED_HOURS))