Calendar object

[#1]

Hi,

   I have two calendar objects: StartDate and EndDate. I used the variables vStartDate and vEndDate. starttime is my date field, since it has time also am using date(starttime) to get the date alone.

In the calendar object -> properties -> General for variable vStartDate i gave min value as "=date(min(starttime))" and max value as"Date(Max(starttime))" , for vEndDate also gave the same.

And a button for selection, action->'select in field' , in the field name i gave starttime and in the search string i gave " ='>='&Date(vStartDate,'M/D/YYYY')&'<='& Date(vEndDate,'M/D/YYYY')"

by giving this my table containing the date field should change but its not.

please correct me if i done wrong.

Thanks

[#2]

Does the field in which you want to perform the selection have the same date format 'M/D/YYYY'?
Also the example qwv would be helpful.

[#3]

Yes its like 6/29/2006

[#4]

Hi,

     Can you please attach sample file regarding this issue.

Regards,

Ashutosh

[saumyashah90]

Try this
Date($(vStartDate),'MM/DD/YYYY')

[#6]

Hire is the sample, hope that will help.

[#7]

hi,

     First  clear one thing. do you want to add date into your date field which is selected in calender object  or you want to only select in list box  these selected dates??

Thanks,

Ashutosh

[christian77]

Hi.

You may want to use a slide or the calendar with multiple value.

Formats are important in calendars. Correct the format in the number tab.

Also, if you say vStartTime = min(Date), when you filter a date, the calendar will show only one date. You may want to say vStartDay = max({1}Date), that way it'll take the whole QlikView data base.

You can asign a format for that field for the whole document in the doc properties, number tab. Formats can be copied and paste to avoid misformats.

[#9]

I am not the one who have problem. I posted a working example for Remya.

[christian77]

Yeap.

All postings go to all participants, I believe. If you see my first post is in response to the person who started the question, that is Remya.

Salutes Alex.