Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have three list box Year,Day(1,2,3..) and monthNam(Jan,Feb,Mar..) and 2 calendar object.
Based on the selected start date and end date in the two calendar objects i need to auto select year, days and MonthName in the 3 list boxes.
Year and Day i am able to select by using Search String action on respective fields when start date and end date are selected,
But same logic when i apply on Monthname it does not work. Below are the search strings i tried to auto select month but doesn't work
='=' & Month(vFromDate) & '=' & Month(vTodate)
='>=' & Month(vFromDate) & '<=' & Month(vTodate)
Can someone helpout on this
Hi,
Can you please post your sample file
Hi,
I have attached sample.qvw. In this when you select any start date and end date in calendar object, the year and day listbox auto select based on calendar dates.
I have done this by adding trigger on variables vstartdate and venddate which are used in calendar object.
But when same logic i apply on MonthName it fails
Try something like:
='(>=' & Month(vFromDate) & '| <=' & Month(vTodate)&')'
Hi,
See the expression for Month and Day list boxes.
Regards,
Abey
Thanks for the reply, but it still doesn't work
Hi
Try like this
Instead of selectedField option, try select possible in both variable trigger
Select Possible -> MonthName
Hope tat helps
i didn't got you Abey. As in list box i am directly using field. So the expression will be empty. Moreover day part is working , i am facing issue only in month.
Hi
To create a variable
vstartdate=makedate(year(venddate),01,01)
venddate
vpstartdate=addyears(vstartdate,-1)
vpenddate=addyear(venddate,-1)
Thanks a lot, select possible solves my issue.