select month name based on selected date

[#1]

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

[#2]

Hi,

Can you please post your sample file

[#3]

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

[tresesco]

Try something like:

='(>=' & Month(vFromDate) & '| <=' & Month(vTodate)&')'

[abeyphilip]

Hi,

See the expression for Month and Day list boxes.

Regards,

Abey

[#6]

Thanks for the reply, but it still doesn't work

[MayilVahanan]

Hi

Try like this

Instead of selectedField option, try select possible in both variable trigger

Select Possible -> MonthName

Hope tat helps

[#8]

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.

[Anonymous]

Hi

To create a variable

vstartdate=makedate(year(venddate),01,01)

venddate

vpstartdate=addyears(vstartdate,-1)

vpenddate=addyear(venddate,-1)

[#10]

Thanks a lot, select possible solves my issue.