I have the attached qvw that creates our business calendar based on broadcast calendar. This broadcast calender is then used in all our qvws. I need to dynamically capture the 2nd week of every month so when you open any qvw the month selection in the filter is based on the month that is in the 2nd week of the broadcast month. Any suggestions on how get the second week of the broadcast month dynamically?
Thank you.This works! However, I am having problems with the trigger because the requirement now is to have all months selected in the Month filter listbox every time we are in Week 2 of every month. For example, when April 8, 2013 arrives (Week 2 of April), I need the months Jan, Feb, March selected in the Month filter box, when May 6th, 2013 (Week 2 of May) arrives I need Jan, Feb, March, April months selected and so on.