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.
Actually my date field 'starttime' is "6/28/2006 12:10:14 AM" like this, i use date(starttime) for getting the date for my table. If i select a date from the list box, table values are changing according to the date. But if i select from calendar object nothing changes in the table as well as list box.
