2 Replies Latest reply: Sep 30, 2011 12:14 AM by aggaayathri RSS

    Macros

    aggaayathri

      Hi,

      I want to know how to select range of dates in the listbox when selecting start date and end date in the inputbox using macros??

       

      Please help me out!!

        • Re: Macros
          Deepak Vadithala

          Hi Gaayathri,

           

          This is possible by using Set Analysis. I am not sure why you wanted to use the Macros. I would recommend you to avoid using Macros whenever possible, unless you have different requirement.

           

          I am attaching an example for your reference. Here is the function I have used to get this working.

           

          SUM( {<MyDate ={">=$(vStartDate) <=$(vEndDate)"} >} Sales)

           

          Where vStartDate and vEndDate are variables which capture the Input Field Values.

           

          I hope this helps! Let me know if you have any questions.

           

          Cheers,

          DV